Обсуждение: user defined function in CHECK constraint

Поиск
Список
Период
Сортировка

user defined function in CHECK constraint

От
Christopher Kings-Lynne
Дата:
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



Re: user defined function in CHECK constraint

От
Tom Lane
Дата:
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