This project is archived and is in readonly mode.
[patch] fix db:structure:dump for multiple schemas in postgres
Reported by Jeff Dean | May 22nd, 2009 @ 05:51 AM | in 2.x
This patch fixes a bug in db:structure:dump for postgres when there are multiple schema_search_paths.
development:
adapter: postgresql
username: user
schema_search_path: foo, bar
password:
Currently in rails, if you have a database.yml with multiple values in schema_search_path, db:structure:dump blows up. This patch properly formats the above database.yml command like so:
@@@pg_dump -i -U "user" -s -x -O -f development_structure.sql --schema=bar --schema=foo my_database@@@
Postgres allows for multiple schemas to be passed to pgdump - for more information see:
Comments and changes to this ticket
-
Joseph Palermo May 28th, 2009 @ 08:28 PM
+1
Seems to work to me. I see no way this could break anything either.
-
Repository June 1st, 2009 @ 01:13 AM
- State changed from “new” to “committed”
(from [b3839f1c98ab6824091c517f6e2e6e3a024c3e13]) Updated the db:structure:dump task to properly format the pgdump command when you have multiple schemas in your schema search path.
Signed-off-by: Michael Koziarski michael@koziarski.com
[#2695 state:committed] http://github.com/rails/rails/commit/b3839f1c98ab6824091c517f6e2e6e...
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
<h2 style="font-size: 14px">Tickets have moved to Github</h2>
The new ticket tracker is available at <a href="https://github.com/rails/rails/issues">https://github.com/rails/rails/issues</a>
People watching this ticket
Julian Mehnle
Michael Koziarski
Attachments
Referenced by
-
3665
[patch] schema path in postgresql is broken
I think this is a duplicate of #2695, which
has been reso...
-
2514
Patch - rake task db:structure:dump broken for postgres w/ multiple schema
I think this is a duplicate of #2695, which
has been reso...
-
2695
[patch] fix db:structure:dump for multiple schemas in postgres
Signed-off-by: Michael Koziarski michael@koziarski.com
[#...