Re: [PATCHES] system catalog relation of a table and a serial sequence

[2001-12-16 23:23] Peter Eisentraut said:
| Tom Lane writes:
|
| > I think it'd be a bit surprising if "pg_dump -t table" would dump
| > sequences declared independently of the table. An example where you'd
| > likely not be happy with that is if the same sequence is being used to
| > feed multiple tables.
| >
| > I agree that dumping all such sequences will often be the desired
| > behavior, but that doesn't leave me convinced that it's the right
| > thing to do.
| >
| > Any comments out there?
|
| The more general question is: Should 'pg_dump -t table' dump all objects
| that "table" depends on? Keep in mind that this could mean you have to
| dump the entire database (think foreign keys). In my mind, dumping an
| arbitrary subset of dependencies is not a proper solution, though.

Do you care to share your ideas on what a proper solution /would/ be?

I agree wholly with you that it is worse to dump the "arbitrary
subset" of related objects along with a table.

Assuming that 'pg_dump $ARGS db_1 > psql db_2' should never fail,
we must either dump only table schema for ARGS="-t table" or dump
/all/ dependencies for the same ARGS.

Clearly, we are not in a position to dump all dependencies right now.
Can we make the change that '-t table' is limited to dumping schema?

brent

--
"Develop your talent, man, and leave the world something. Records are
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing." -- Duane Allman