From: | Andreas Wernitznig <andreas(at)insilico(dot)com> |
---|---|
To: | "Pawel Pawlowski" <pawel(dot)pawlowski(at)breitenbach(dot)pl> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: PD: triggered data change violation on relation "tbl_b" |
Date: | 2001-08-29 11:20:54 |
Message-ID: | 20010829132054.2a87f6b3.andreas@insilico.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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" <pawel(dot)pawlowski(at)breitenbach(dot)pl> wrote:
> 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 (pn_id)
> );
> CREATE TABLE tbl_b
> (
> pc_id INT4 NOT NULL REFERENCES tbl_a (pn_id) ON UPDATE CASCADE ON DELETE CASCADE,
> pc_b VARCHAR(40) NOT NULL,
> PRIMARY KEY (pc_id, pc_b)
> );
> INSERT INTO tbl_a VALUES (1, 'xxx');
>
> And this is the sample script that I use to generete this bug:
>
> begin transaction;
> insert into tbl_b values (1, 'xxx');
> delete from tbl_b where pc_id=1;
> ERROR: triggered data change violation on relation "tbl_b"
>
> How to solve this problem ?????
------------------------------
Andreas Wernitznig
Insilico Software GmbH
E-Mail: andreas(at)insilico(dot)com
Web: www.insilico.com
------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Pawel Pawlowski | 2001-08-29 11:43:15 | Odp: PD: triggered data change violation on relation "tbl_b" |
Previous Message | Pawel Pawlowski | 2001-08-29 11:18:02 | PD: triggered data change violation on relation "tbl_b" |