Re: CHECK constraints in pg_dump - Mailing list pgsql-hackers

From Tom Lane
Subject Re: CHECK constraints in pg_dump
Date
Msg-id 27689.1046242608@sss.pgh.pa.us
Whole thread Raw
In response to CHECK constraints in pg_dump  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> I notice that we're still dumping CHECK constraints as part of the CREATE
> TABLE statement, and not as an ALTER TABLE statement after the data has been
> loaded.

> Should we move it to after the data for speed purposes, like we have with
> all other constraints?

Why would there be any speed advantage?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: CHECK constraints in pg_dump
Next
From: Dave Cramer
Date:
Subject: Re: autocommit off mode, how does it work?