user defined function in CHECK constraint
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
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