Hi,

I've just talked to a few users on IRC who cannot restore dumps because 
they use user-defined functions in CHECK constraints.

Any chance this will be fixed using dependencies?  Or maybe it's just 
easy to put all ADD CHECKs at the very end?

Chris


Tue, 24 Feb 2004 12:17:20 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
user defined function in CHECK constraint
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> I've just talked to a few users on IRC who cannot restore dumps because 
> they use user-defined functions in CHECK constraints.

> Any chance this will be fixed using dependencies?

It's done in CVS tip.

If you were brave you could use CVS-tip pg_dump with a 7.4 database.
AFAIR we haven't yet done anything that would break compatibility
of a dump script.  I'm just not going to promise that CVS-tip pg_dump
is up to production quality yet... test it first...

			regards, tom lane

Tue, 24 Feb 2004 00:13:50 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: user defined function in CHECK constraint 