Re: Rows missing from table despite FK constraint - Mailing list pgsql-general

From Tom Lane
Subject Re: Rows missing from table despite FK constraint
Date
Msg-id 14973.1262991238@sss.pgh.pa.us
Whole thread Raw
In response to Re: Rows missing from table despite FK constraint  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List pgsql-general
Alban Hertroys <dalroi@solfertje.student.utwente.nl> writes:
> You seem to know what you're doing, but just in case we missed something as this is strange enough to have even the
devsscratching their heads. The rows are there, so it _has_ to be an index or a transaction visibility issue... 

The successful fetch-by-ctid test seems to have eliminated the
transaction-visibility-problem theory too.  The whole thing is
passing strange at this point.

            regards, tom lane

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Rows missing from table despite FK constraint
Next
From: Ben Chobot
Date:
Subject: Is there a kinder, gentler log_exector_stats?