Re: pg_dump and ON DELETE CASCADE problem

Thanks for the suggestion. I'm not sure what you mean when you say I should restore to a file. Do you mean I should
dumpthe database to an SQL file instead of the "compressed" format? 

What do you think I will find?

In the database dump, it is including a row that should be marked as deleted. I can select on that key in the
productiondatabase and get zero rows, and I can select on that key in the restored database and find the row. When I
ignoreerrors the data is restored, but the foreign key can't be created (and that is the only error I encounter). The
presenceof the data in the dump can not be contested... :) 



--- On Thu, 12/10/09, Adrian Klaver <aklaver@comcast.net> wrote:

>
> One thing that comes to mind is to restore the dump file to
> a file instead of a
> database and see what is being dumped from the live
> database.
>
>
>
> --
> Adrian Klaver
> aklaver@comcast.net
>