current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite

I want to have two schemas(except public) in a pgsql database on heroku. On local I have done it like imported the data to public schema and renamed it to the name of my choice. In the similar manner i created two schema under one DB and connected it to a rails application using 

search_schema_path: 'schema1, schema2'

Now I want to do the same on heroku and tried the same procedure. But it seems that, rails can not find tables from the DB. I am getting the error relationship "delayed_jobs" does not exists. Please suggest me how to do it.

Thanks in advance for any help.

share|improve this question

1 Answer 1

up vote 2 down vote

When your Rails app is deployed on Heroku, an automatically generated database.yml over-writes your applications database.yml, which is dropping your schema_search_path setting, reseting it to public.

You can add an initializer that reset the value after load. For example, config/initializers/postgres_schema.rb:

ActiveRecord::Base.connection.schema_search_path = 'schema1, schema2'

You'll need to be careful to set this anywhere you're re-connecting or re-setting.

share|improve this answer
    
Thanks @Winfield .... I did the same :) –  vikram Dec 21 '13 at 3:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.