Forum: Ruby on Rails PostgreSQL schema_search_path ignores case

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
Ricardo A. (Guest)
on 2008-10-30 19:03
(Received via mailing list)
  I have to connect to a legacy DB wich has a schema called

  I setup my database.yml to:

schema_search_path: Financeiro

when activerecord tries to find something I get the following error:

ActiveRecord::StatementInvalid: RuntimeError: ERROR     C3F000  Mschema
"financeiro" does not exist
F.\src\backend\catalog\namespace.c      L2898   Rassign_search_path: SET
search_path TO Financeiro from

Note that in the error message I get financeiro (downcase).

If I rename the schema to financeiro downcase it works well. But it is
possible in the production environment.


Ricardo A.
Acras Sistemas
This topic is locked and can not be replied to.