"Dmitry Koterov" <[EMAIL PROTECTED]> writes: > Thank you for a possible solution. > But what about the database which exists and works correctly (and conforms > all the standards from the documentation), but dump+restore sequence is > failed for it? Does it mean that pg_dump should be improved to pass > dump+restore sequence?
No matter what pg_dump does, it can never guarantee that a non-immutable check constraint will still pass at restore time ... and that's basically what you've got, if the check function is search-path-sensitive. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers