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