Howdy,
Have any of the PostgreSQL users here upgraded to 8.2 and used it with Rails apps?
So far my tests show that it seems to work just fine but I thought I would ask before moving closer to deploying it in production.
Cheers, Hunter
I've been unable to get Postgres 8.2 working. Fedora Core 4, Rails 1.1.6, ruby 1.8.4, ruby-postgres gem. I get the error uninitialized constant: PGConn
Don't know if this is a Rails problem or the ruby-postgres bindings.
I think it’s ruby-postgres issue. Run backend in 8.2 but stay with 8.1.x as client library.
Are you using the pure ruby driver or the C based one?
The C based one just link against libpq.so. So it should work against 8.2 as well as earlier versions. If it doesn't, a recompile of the native extension should take care of it.
As for the pure-ruby one, I can't comment on it as I don't use it. The native one works perfectly for me. I even added to it proper support for LISTEN/NOTIFY that let you listen on notification without using any CPU while waiting [1].
Guy.