Re: Inconsistent treatment of serials in pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Inconsistent treatment of serials in pg_dump
Date: 2011-05-09 20:16:05
Message-ID: 3717.1304972165@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus <josh(at)agliodbs(dot)com> writes:
> It seems that if I exclude a table using -T, its dependant sequences do
> not get excluded. But if I include it using -t, its dependent sequences
> *do* get included.

> Is there a reason this is a good idea, or is it just an oversight?

It's not immediately clear to me that those switches ought to be exact
inverses.

As a counterexample, consider the case where multiple tables share the
same sequence. Suppressing one of the tables with -T ought not lead to
suppressing the sequence.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-05-09 20:21:30 Re: Why not install pgstattuple by default?
Previous Message Robert Haas 2011-05-09 19:57:12 Re: Collation mega-cleanups