Обсуждение: SO question about disappearing row

Поиск
Список
Период
Сортировка

SO question about disappearing row

От
Andomar
Дата:

One transaction updates a row with the same values, causing another transaction to return an empty set. This is surprising as the row passes the where clause both before and after the update.

Is there a way to have Postgres explain why the outer query drops a row even though the query plan does not show a filter?

Cheers,
Andomar