plpgsql constraint checked data fails to restore

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/

Responses

Browse pgsql-general by date

  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 =