Postgres Pro
Downloads
Home   >   mailing lists

Teaching pg_dump to use NOT VALID constraints - Mailing list pgsql-hackers

From Simon Riggs
Subject Teaching pg_dump to use NOT VALID constraints
Date
Msg-id CA+U5nMLkRsR+fqhC7qzHprJ6FhNS0idPfpTieB-qzFYGdyYWug@mail.gmail.com
Whole thread Raw
Responses Re: Teaching pg_dump to use NOT VALID constraints  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Tree view 
Magnus and I discussed the need for pg_dump to offer the use of NOT
VALID constraints.
Here's the patch.


 pg_dump --no-revalidaton

will add "NOT VALID" onto the recreation SQL for any FKs, but only for
ones that were already known to be valid.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: using custom scan nodes to prototype parallel sequential scan
Next
From: Magnus Hagander
Date:
Subject: Re: SSL information view