Re: URGENT: referential integrity problem

On Wednesday 29 Jan 2003 12:18 pm, pginfo wrote:
> I have 2 tables, in the first one I have field that points to the table
> key from the second.
[snip]
> After few min. pg drops with:
> ERROR:  <unnamed> referential integrity violation - key referenced from
> a_table1 not found in a_table2 !
>
> My questions:
> How is it possible, that pg do not check the references by inserts?

Might be a damaged index - try a REINDEX (specified in the SQL reference
manual). I'd also run some tests against your hardware, make sure you don't
have any memory or disk problems.

> How can I check the db integrity for all tables at once ( I need to be
> sure, that do not exists any problems. It is production server).

Simplest way I can think of would be to pg_dump and restore to a test
installation.

--
  Richard Huxton