From: Philip Warner <pjw@rhyme.com.au>
To: Josh Berkus <josh@agliodbs.com>
To: abief_ag_-postgresql@yahoo.com, Kenneth Gonsalves <lawgon@thenilgiris.com>
To: pgsql-sql@postgresql.org
Subject: Re: from PG_DUMP to CVS
Date: Sun, 29 Aug 2004 02:10:26 +1000
Message-ID: <6.1.1.1.0.20040829020436.04705d30@203.8.195.10> (raw)
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>
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 |/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pjw@rhyme.com.au, josh@agliodbs.com, lawgon@thenilgiris.com
Subject: Re: from PG_DUMP to CVS
In-Reply-To: <6.1.1.1.0.20040829020436.04705d30@203.8.195.10>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox