sleepwalker
2011-May-18 13:15 UTC
Postgresql schemas in migrations and db:schema:dump task
Does Rails 3 support native working with postgresql schemas, or I should try some own solution? I have some already-created postgresql database with 4 or somth schemas. By putting "schema_search_path: ejabber, public, admin, statistic" into database.yml I told Rails that I have more than 1 schema. When I make "rake db:schema:dump" I have tables from all 4 schemas alphabetical with no schema-dependency. So the question is, when I''ll be ready to deploy my app on production (via capistrano, for example), is there would be still 4 schemas in database, or only one? How does Rails keeps knowing which table belongs to which schema? -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
sleepwalker
2011-May-30 13:51 UTC
Re: Postgresql schemas in migrations and db:schema:dump task
Sad(( is here nobody use postgresql with rails? Or I''m asking something wrong? On 18 май, 17:15, sleepwalker <krivich.ekater...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Does Rails 3 support native working withpostgresqlschemas, or I > should try some own solution? > > I have some already-createdpostgresqldatabase with 4 or somth > schemas. > By putting "schema_search_path: ejabber, public, admin, statistic" > into database.yml I told Rails that I have more than 1schema. > When I make "rake db:schema:dump" I have tables from all 4 schemas > alphabetical with noschema-dependency. > > So the question is, when I''ll be ready to deploy my app on production > (via capistrano, for example), is there would be still 4 schemas in > database, or only one? How does Rails keeps knowing which table > belongs to whichschema?-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.