| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-08-20 02:49:40 | Re: Large Object / libPQ : problem |
| Previous Message | Chris | 2000-08-19 22:41:34 | Large Object / libPQ : problem |