Postgres Pro
Downloads
Home   >   mailing lists

Re: Cannot delete newly inserted record while inside a transaction - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: Cannot delete newly inserted record while inside a transaction
Date
Msg-id Pine.LNX.4.21.0008200239220.461-100000@localhost.localdomain
Whole thread Raw
In response to Cannot delete newly inserted record while inside a transaction  ("Woodcock, Steve" <SWoodcock@scholastic.co.uk>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: Chris
Date:
Subject: Large Object / libPQ : problem
Next
From: Tom Lane
Date:
Subject: Re: Large Object / libPQ : problem