Re: [GENERAL] How do I connect postgres table structures and view structures to an existing svn repository?
On Aug 1, 2007, at 10:56 AM, Richard Huxton wrote: You could write a small cron-script that dumped the schema once every 5 minutes so it could be picked up by svn. I think most people have a separate collection of schema-creation/ update scripts that they keep under version control. All changes are then through running these. You would have to do it via polling, since schema changes cause no events to be generated (ie, you can't attach a trigger to a schema change.) But the *right* way is to make schema change scripts as delta files, add them to your repo, test them on your staging environment, then apply them to your production environment. That way you can reconstruct your DB at any time and *know* it will work. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] How do I connect postgres table structures and view structures to an existing svn repository?
Hi, I am trying to store schema definitions in version-control which I can do by saving the definition and then importing into svn, but I would like it to be automatic , so that when an update occurs to a table or view within postgres then that table or view is flagged within svn. This would be similar to what I currently do with source code that I have for a web app within eclipse. On 8/1/07, Tino Wildenhain [EMAIL PROTECTED] wrote: John Mitchell schrieb: Hi, How do I connect postgres table structures and view structures to an existing svn repository? Please elaborate: what do you mean with connect? If you want to version control your DDL, people use pgdump to create individual dumps (as sql text files) and just add/commit them to the repository. Regards Tino -- John J. Mitchell
Re: [GENERAL] How do I connect postgres table structures and view structures to an existing svn repository?
John Mitchell schrieb: Hi, How do I connect postgres table structures and view structures to an existing svn repository? Please elaborate: what do you mean with connect? If you want to version control your DDL, people use pgdump to create individual dumps (as sql text files) and just add/commit them to the repository. Regards Tino ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] How do I connect postgres table structures and view structures to an existing svn repository?
John Mitchell wrote: I am trying to store schema definitions in version-control which I can do by saving the definition and then importing into svn, but I would like it to be automatic , so that when an update occurs to a table or view within postgres then that table or view is flagged within svn. This would be similar to what I currently do with source code that I have for a web app within eclipse. Ah! I'm not aware of any such system. You could write a small cron-script that dumped the schema once every 5 minutes so it could be picked up by svn. I think most people have a separate collection of schema-creation/update scripts that they keep under version control. All changes are then through running these. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq