Re: referential integrity violation - key referenced from

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Luiz Henrique <luizhwk(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: referential integrity violation - key referenced from
Date: 2006-08-04 16:19:01
Message-ID: 20060804091309.E15884@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kris Jurka 2006-08-04 17:25:00 Re: The column index is out of range in PostgreSQL + resolve
Previous Message Tom Lane 2006-08-04 15:08:08 Re: Restoring 7.4 "pg_dumpall -o" output in 8.1 fails