From: | "Lee Harr" <missive(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | plpgsql constraint checked data fails to restore |
Date: | 2005-06-20 01:19:05 |
Message-ID: | BAY7-F32E1806075EA68C2B0E859B1E90@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2005-06-20 01:40:49 | Re: user/groups query ? |
Previous Message | Tom Lane | 2005-06-20 01:13:39 | Re: unicode and = |