Re: pg_dump: fail to restore partition table with serial type - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump: fail to restore partition table with serial type
Date
Msg-id 30015.1560386817@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump: fail to restore partition table with serial type  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: pg_dump: fail to restore partition table with serial type  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> There was indeed one more problem, that only the pg10 pg_upgrade test
> detected.  Namely, binary-upgrade dump didn't restore for locally
> defined constraints: they were dumped twice, first in the table
> definition and later by the ALTER TABLE ADD CONSTRAINT bit for binary
> upgrade that I had failed to notice.  Ooops.  The reason pg10 detected
> it and the other branches didn't, is that the only constraint of this
> ilk that remained after running regress was removed by 05bd889904e0 :-(

Seems like we'd better put back some coverage for that case, no?
But I'm confused by your reference to 05bd889904e0.  It looks like
that didn't change anything about tables that weren't getting dropped
anyhow.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: proposal: new polymorphic types - commontype and commontypearray
Next
From: Peter Geoghegan
Date:
Subject: Re: PG 12 draft release notes