X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DC4285E46F3 for ; Sat, 28 Aug 2004 13:10:42 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11668-10 for ; Sat, 28 Aug 2004 16:10:41 +0000 (GMT) Received: from acheron.rime.com.au (acheron.rhyme.com.au [203.208.66.49]) by svr1.postgresql.org (Postfix) with ESMTP id BEC7B5E46DC for ; Sat, 28 Aug 2004 13:10:27 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386)) with ESMTP id 32B26267407; Sun, 29 Aug 2004 02:10:31 +1000 (EST) Received: from by localhost (amavisd-new, port ) id XXhha0af; Sun, 29 Aug 2004 02:10:29 +1000 (EST) Received: by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386), from userid 527) id 18D96267408; Sun, 29 Aug 2004 02:10:29 +1000 (EST) Received: from hephaestus.rhyme.com.au (hephaestus.rime.com.au [203.8.195.122]) by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386)) with ESMTP id F420C267407; Sun, 29 Aug 2004 02:10:26 +1000 (EST) Message-Id: <6.1.1.1.0.20040829020436.04705d30@203.8.195.10> X-Sender: pjw@203.8.195.10 X-Mailer: QUALCOMM Windows Eudora Version 6.1.1.1 Date: Sun, 29 Aug 2004 02:10:26 +1000 To: Josh Berkus , abief_ag_-postgresql@yahoo.com, Kenneth Gonsalves , pgsql-sql@postgresql.org From: Philip Warner Subject: Re: from PG_DUMP to CVS In-Reply-To: <200408270902.20350.josh@agliodbs.com> References: <20040826120504.58934.qmail@web13925.mail.yahoo.com> <200408262138.30766.josh@agliodbs.com> <6.1.1.1.0.20040827210840.06bd3ad0@203.8.195.10> <200408270902.20350.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at rhyme.com.au X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/315 X-Sequence-Number: 18812 At 02:02 AM 28/08/2004, Josh Berkus wrote: >some-dbname/some-schema/TABLES/sometable.sql >some-dbname/some-schema/VIEWS/someview.sql >some-dbname/some-schema/FUNCTIONS/somefunction-param{codes}.sql >some-dbname/some-schema/TYPES/sometype.sql >some-dbname/some-schema/OPERATORS/OPsomeoperator.sql > >In this last, all dependant objects of, for example, a table (rules, >triggers, >indexes, etc. ) would be rolled up into one file. It's this last version >that I personally favor. Not sure I like it from the PoV of easily seeing what has changed. Similarly: >some-dbname/some-schema/TABLES/sometable/create.sql >some-dbname/some-schema/TABLES/sometable/indexes.sql >some-dbname/some-schema/TABLES/sometable/constraints.sql combines all indexes into one file. It also has the disadvantage if being impossible to construct from an existing dump file. I'd like to be able to construct the structure from the information stored in a dump file, without parsing SQL. OTOH, it might be nice to add some more information to the dump file. ---------------------------------------------------------------- Philip Warner | __---_____ Albatross Consulting Pty. Ltd. |----/ - \ (A.B.N. 75 008 659 498) | /(@) ______---_ Tel: (+61) 0500 83 82 81 | _________ \ Fax: (+61) 03 5330 3172 | ___________ | Http://www.rhyme.com.au | / \| | --________-- PGP key available upon request, | / and from pgp.mit.edu:11371 |/