plpgsql constraint checked data fails to restore
От | Lee Harr |
---|---|
Тема | plpgsql constraint checked data fails to restore |
Дата | |
Msg-id | BAY7-F32E1806075EA68C2B0E859B1E90@phx.gbl обсуждение исходный текст |
Ответы |
Re: plpgsql constraint checked data fails to restore
|
Список | 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/
В списке pgsql-general по дате отправления: