Hi all !
This is very strange. I am attempting to get my application running
on PostgreSQL (from MySQL), and I get this error:
ActiveRecord::StatementInvalid: PGError: ERREUR: la colonne «Party»
n’existe pas
: SELECT * FROM contact_routes WHERE (routable_type = “Party” AND
routable_id = 1000013) ORDER BY position DESC LIMIT 1
/home/francois/src/xlsuite.org/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:128:in
log' /home/francois/src/xlsuite.org/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:152:in execute’
/home/francois/src/xlsuite.org/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:433:in
select' /home/francois/src/xlsuite.org/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in select_all’
/home/francois/src/xlsuite.org/vendor/rails/activerecord/lib/active_record/base.rb:427:in
find_by_sql' /home/francois/src/xlsuite.org/vendor/rails/activerecord/lib/active_record/base.rb:997:in find_every’
/home/francois/src/xlsuite.org/vendor/rails/activerecord/lib/active_record/base.rb:991:in
find_initial' /home/francois/src/xlsuite.org/vendor/rails/activerecord/lib/active_record/base.rb:417:in find’
It translates to “The Party column does not exist”. I ran the
statement in psql, and sure enough, I get the same error. If I quote
the routable_type column’s value using single-quotes, I get the
expected results.
My models look like this:
class Party < AR::B
has_many :contact_routes, :as => :routable
end
class ContactRoute < AR::B
acts_as_list
belongs_to :routable, :polymorphic => true
end
I’m on the 1.2 stable branch, using Ruby 1.8.4 and PostgreSQL 8.1.
Thanks !
François Beausoleil
http://blog.teksol.info/
http://piston.rubyforge.org/