I have a database running 8.0.1
One of the tables uses a plpgsql function as a
check constraint. There is data in the table that
passed the constraint.
The problem comes when trying to restore the
database using a file created by pg_dump.
Some of the data required by the check function
is being restored after the data being checked
by the function and so it all fails the constraint.
I have a small (200 lines) dump file which shows
the problem if that will help.
Is there a way to ensure that the checked data
gets listed last in the dump file? Some other
way?
I actually have this database deployed on 7.4.x
so a fix that also works for that series would be
ideal...
Thanks for your time.
_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
