Re: Rows missing from table despite FK constraint

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Rows missing from table despite FK constraint
Дата
Msg-id 14973.1262991238@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Rows missing from table despite FK constraint  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Список 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 по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Rows missing from table despite FK constraint
Следующее
От: Ben Chobot
Дата:
Сообщение: Is there a kinder, gentler log_exector_stats?