Couldn't create database, undefined method `quote_ident'?

Question

Hello, when trying to run:

rake db:create

I get the following error:

undefined method `quote_ident' for PGconn:Class

Having googled for a solution, it seems by adding:

def PGconn.quote_ident(name)
%("#{name}")
end

to config/initializers/new_rails_defaults.rb should solve the problem, but I'm still getting the error! Any suggestions? Thank you

See error here: http://github.com/mneumann/postgres-pr/issues/issue/1

Answer 1

I would think this is a version mismatch.

Are you sure you have the right versions of everything installed? E.g. Postgres server, libpgsql (Postgres client library), whatever library Ruby has for accessing Postgres, and finally your application (rake)?

Answer 2

The solution is to add:

def PGconn.quote_ident(name)
%("#{name}")
end

to active_record/connection_adapters/postgresql_adapter.rb