Rows missing from table despite FK constraint

From: Konrad Garus <konrad(dot)garus(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Rows missing from table despite FK constraint
Date: 2010-01-07 10:12:24
Message-ID: 6645f6441001070212h51919077rea8ae68e44683f71@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We use PG 8.3. We use pg_dump and pg_restore overnight to create
copies of main database for reporting etc. One dump/restore runs at 9
PM, another at 11 PM.

Today I discovered that the restore at 11 PM failed to recreate a
foreign key constraint, because one row from master table was missing.
It is also missing from main database, but not from the 9 PM dump.

The main database is in curious state: The row from master table is
missing, the row referencing it from slave table is present, and
finally the FK constraint on slave is in place.

Do you have any ideas on how it could possibly happen? What research
could help find the root cause and fix the database?

Thanks.

--
Konrad Garus

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dimitri Fontaine 2010-01-07 10:29:50 Re: PostgreSQL Write Performance
Previous Message Vincenzo Romano 2010-01-07 09:17:46 A maybe-bug?