Re: [GENERAL] pg_dump of only the structure from a client such as ruby

2007-08-07 Thread Mason Hale
If you haven't seen it already, there is a rails plugin that adds support for foreign-key dependencies (among other things) to the migration domain specific language (DSL): http://www.redhillonrails.org/#foreign_key_migrations Another useful plug-in is "Transactional Migrations" which automatical

Re: [GENERAL] pg_dump of only the structure from a client such as ruby

2007-08-06 Thread Michael Glaesemann
On Aug 6, 2007, at 13:17 , Perry Smith wrote: I'm using config.active_record.schema_format = :sql. I like the idea of constraints in the db -- I know that goes against a lot of rails ideas. I think most who choose Postgres come to the same conclusion. Though do take care not to confuse R

Re: [GENERAL] pg_dump of only the structure from a client such as ruby

2007-08-06 Thread Michael Glaesemann
On Aug 5, 2007, at 18:58 , Perry Smith wrote: I find it odd that you are resistant to the idea. To me, the advantages are clear if it can be done without a tremendous amount of work. Why horse around with the environment variables to set such things as password, call sh, just to call pg_d

Re: [GENERAL] pg_dump of only the structure from a client such as ruby

2007-08-05 Thread Perry Smith
On Aug 5, 2007, at 7:37 PM, Tom Lane wrote: PS: *please* see if you can get them to take out the usage of pg_dump's -i switch. Having code invoke that blindly borders on criminal negligence. http://dev.rubyonrails.org/ticket/9198 Thank you again. Take care, Perry Smith ( [EMAIL PROTECTED]

Re: [GENERAL] pg_dump of only the structure from a client such as ruby

2007-08-05 Thread Perry Smith
On Aug 5, 2007, at 7:37 PM, Tom Lane wrote: Perry Smith <[EMAIL PROTECTED]> writes: I find it odd that you are resistant to the idea. To me, the advantages are clear if it can be done without a tremendous amount of work. Well, it can't. pg_dump is an enormously complicated and frequently ch

Re: [GENERAL] pg_dump of only the structure from a client such as ruby

2007-08-05 Thread Tom Lane
Perry Smith <[EMAIL PROTECTED]> writes: > I find it odd that you are resistant to the idea. To me, the > advantages are clear if it can be done without a tremendous amount of > work. Well, it can't. pg_dump is an enormously complicated and frequently changed bit of code, and so you really re

Re: [GENERAL] pg_dump of only the structure from a client such as ruby

2007-08-05 Thread Perry Smith
On Aug 5, 2007, at 6:07 PM, Michael Glaesemann wrote: On Aug 5, 2007, at 16:31 , Perry Smith wrote: I'm trying to help out the rails people. Currently they have "rake" scripts which call pg_dump, dropdb, createdb, and psql. It would be nicer if this could be done via a database connectio

Re: [GENERAL] pg_dump of only the structure from a client such as ruby

2007-08-05 Thread Michael Glaesemann
On Aug 5, 2007, at 16:31 , Perry Smith wrote: I'm trying to help out the rails people. Currently they have "rake" scripts which call pg_dump, dropdb, createdb, and psql. It would be nicer if this could be done via a database connection. Why would this be nicer? What's the advantage? pg_d