Re: Cannot delete newly inserted record while inside a transaction

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: Cannot delete newly inserted record while inside a transaction
Дата
Msg-id
Pine.LNX.4.21.0008200239220.461-100000@localhost.localdomain
Ответ на
Список
Дерево обсуждения
Cannot delete newly inserted record while inside a transaction "Woodcock, Steve" <SWoodcock@scholastic.co.uk>
Re: Cannot delete newly inserted record while inside a transaction Peter Eisentraut <peter_e@gmx.net>
Woodcock, Steve writes:

> Trying to delete a record inserted in the same transaction fails
> if the table is referenced from another table (even if the referencing
> table is empty).

This is correct behaviour, specified in SQL. It's potentially overly
restrictive, but we're not to decide that.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden
В списке pgsql-bugs по дате отправления
От: Chris
Дата:
Сообщение: Large Object / libPQ : problem
От: Tom Lane
Дата:
FAQ