Search Postgresql Archives

plpgsql constraint checked data fails to restore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux