# PostgreSQL schema\_search\_path ignores case

**URL:** <https://www.ruby-forum.com/t/postgresql-schema-search-path-ignores-case/152163>\
**Category:** Rails\
**Created:** [October 30, 2008, 6:03pm UTC](https://www.ruby-forum.com/t/postgresql-schema-search-path-ignores-case/152163 "2008-10-30T18:03:26Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![acras](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f4b2a3/32.png) [@acras](https://www.ruby-forum.com/u/acras)\
**Post date:** [October 30, 2008, 6:03pm UTC](https://www.ruby-forum.com/t/postgresql-schema-search-path-ignores-case/152163/1 "2008-10-30T18:03:26Z")

</div>

Hi,  
I have to connect to a legacy DB wich has a schema called  
“Financeiro”.

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  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/connection\_adapters/abstract\_adapter.rb:147:in  
`log’

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

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

Thanks.

Ricardo A.  
removed\_email\_address@domain.invalid  
Acras Sistemas  
+55+41-3092-6403  
www.acras.com.br