Stephan Szabo <[EMAIL PROTECTED]> writes:
> This was a mistake in the interpretation of the spec (modification of
> the same key row referenced by a foreign key constraint in the same
> statement more than once is an error is how we believe the spec meant
> it, but there's a case where they mentio
This was a mistake in the interpretation of the spec (modification of
the same key row referenced by a foreign key constraint in the same
statement more than once is an error is how we believe the spec meant
it, but there's a case where they mention transaction and it got
misinterpreted). I don'
problem is with triger.
- Wiadomosc oryginalna -
Od: "Andreas Wernitznig" <[EMAIL PROTECTED]>
Do: "Pawel Pawlowski" <[EMAIL PROTECTED]>
DW: <[EMAIL PROTECTED]>
Wyslano: 29 sierpnia 2001 13:20
Temat: Re: [BUGS] PD: triggered data change violation on rela
You cannot insert and delete the same data within one transaction.
Only one change of a row is allowed.
Greetings
Andreas
On Wed, 29 Aug 2001 13:18:02 +0200
"Pawel Pawlowski" <[EMAIL PROTECTED]> wrote:
> When I insert to table new row and after this in the same transaction I delete this
>row I
When I insert to table new row and after this
in the same transaction I delete this row I get such error: triggered data
change violation on relation "tbl_b"
I've created database using simple
script:
CREATE TABLE tbl_a(
pn_id SERIAL,
pn_a VARCHAR(400) NOT NULL, PRIMARY KEY
