Re: bug with constraint dependencies? or bug with - Mailing list pgsql-hackers

From Stephan Szabo
Subject Re: bug with constraint dependencies? or bug with
Date
Msg-id 20030828102857.X9762-100000@megazone.bigpanda.com
Whole thread Raw
In response to Re: bug with constraint dependencies? or bug with  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, 28 Aug 2003, Tom Lane wrote:

> Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> > ... that would only help if the unique constraint were created before the
> > references constraint.
>
> But in any case, pg_dump ought to be careful to dump index creation
> commands before REFERENCES constraints, I should think.  If it isn't
> doing that, there's a performance hit even if the code manages to work.

Good point, the checks would be even slower without the indexes.




pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: New array functions
Next
From: Peter Eisentraut
Date:
Subject: Re: Beta2 Tag'd and Bundled ...