PD: triggered data change violation on relation "tbl_b"

From: "Pawel Pawlowski" <pawel(dot)pawlowski(at)breitenbach(dot)pl>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: PD: triggered data change violation on relation "tbl_b"
Date: 2001-08-29 11:18:02
Message-ID: 004f01c1307c$44c391b0$3200000a@breitenbach.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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 ?????

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andreas Wernitznig 2001-08-29 11:20:54 Re: PD: triggered data change violation on relation "tbl_b"
Previous Message Pawel Pawlowski 2001-08-29 11:00:38 BUG: triggered data change violation on relation "tbl_b"