Re: Suggested fix for pg_dump

The Hermit Hacker <scrappy@hub.org> writes:
> Essentially, worst case scenario, we are going from 'broken->broken' ...

No, I don't think so.  The current pg_dump code is only broken if
you've renamed a column involved in a foreign-key dependency (if I
understood the thread correctly).  But Philip is proposing to change
pg_dump to rely on alter table add constraint for *all* PRIMARY KEY
constructs.  So if alter table add constraint fails, it could break
cases that had nothing to do with either foreign keys or renamed
columns.

I'm not really arguing not to make the change.  I am saying there's
an area here that we'd better take care to test during beta cycle...
        regards, tom lane