Forum: Ruby on Rails weird postgres adapter error

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Dfc408d15775d88aa1a0675744cd70f6?d=identicon&s=25 Jeff Cole (Guest)
on 2005-12-19 23:31
I just ported my Rails app from OSX/Linux to Windows XP for the first
time.  I am running PostgreSQL 8.0 and the postgres-pr 4.0 adapter.
Some of the queries in my Rails app work, but for others I get a weird
error:

ArgumentError: Invalid Ruby/cstring: select sa.name as activity_name,
max(sah.created_at) as created_at
      from  site_activity_histories sah, site_activities sa
      where sah.user_id = 17
      and sah.site_activity_id = sa.id
      and sa.viewable = true
      group by activity_name
      order by created_at desc
...<snip>...
c:/development/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in
`log'
c:/development/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:137:in
`execute'
c:/development/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:351:in
`select'
c:/development/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:118:in
`select_all'
c:/development/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:431:in
`find_by_sql'

Obviously, I am not getting this error in OSX/Linux.  Anyone have any
ideas what is happening?  Is there a better postgres adapter for
Windows?

thanks,
Jeff
This topic is locked and can not be replied to.