On Thu, Dec 10, 2009 at 1:21 PM, CG <cgg...@yahoo.com> wrote: > > 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 dump the 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 production database and get zero rows, and I > can select on that key in the restored database and find the row. When I > ignore errors the data is restored, but the foreign key can't be created (and > that is the only error I encounter). The presence of the data in the dump can > not be contested... :)
This could be a corrupted index problem maybe? If you do this: set enable_indexscan=off; select * from table where key=value; does it still not show up? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
