Re: referential integrity violation - key referenced from - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: referential integrity violation - key referenced from
Date
Msg-id 20060804091309.E15884@megazone.bigpanda.com
Whole thread Raw
In response to Re: referential integrity violation - key referenced from  ("Luiz Henrique" <luizhwk@gmail.com>)
Responses Re: referential integrity violation - key referenced from  ("Luiz Henrique" <luizhwk@gmail.com>)
List pgsql-bugs
On Fri, 4 Aug 2006, Luiz Henrique wrote:

> Hi, could you tell me how postgresql look for a referenced key? It looks in
> table index? Maybe only the index is corrupted?

It basically runs a query like:
 SELECT * FROM parenttable WHERE keycol1 = ? [AND keycol2 = ? ...] FOR
SHARE

It should act like a prepared statement would (which might be different
than it would with the ?s replaced by the actual values).

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Restoring 7.4 "pg_dumpall -o" output in 8.1 fails
Next
From: Kris Jurka
Date:
Subject: Re: The column index is out of range in PostgreSQL + resolve