Skip site navigation (1) Skip section navigation (2)

Re: Cannot delete newly inserted record while inside a transaction

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Woodcock, Steve" <SWoodcock(at)scholastic(dot)co(dot)uk>
Cc: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Cannot delete newly inserted record while inside a transaction
Date: 2000-08-20 00:40:56
Message-ID: Pine.LNX.4.21.0008200239220.461-100000@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-bugs
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(at)gmx(dot)net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2000-08-20 02:49:40
Subject: Re: Large Object / libPQ : problem
Previous:From: ChrisDate: 2000-08-19 22:41:34
Subject: Large Object / libPQ : problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group