Re: referential integrity violation - key referenced from

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: referential integrity violation - key referenced from
Дата
Msg-id 20060804091309.E15884@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Re: referential integrity violation - key referenced from  ("Luiz Henrique" <luizhwk@gmail.com>)
Ответы Re: referential integrity violation - key referenced from  ("Luiz Henrique" <luizhwk@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Restoring 7.4 "pg_dumpall -o" output in 8.1 fails
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: The column index is out of range in PostgreSQL + resolve