Re: Rows missing from table despite FK constraint

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
Cc: Konrad Garus <konrad(dot)garus(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Rows missing from table despite FK constraint
Date: 2010-01-08 22:53:58
Message-ID: 14973.1262991238@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)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 devs scratching 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2010-01-08 23:32:54 Is there a kinder, gentler log_exector_stats?
Previous Message Alban Hertroys 2010-01-08 22:36:02 Re: Rows missing from table despite FK constraint