From: | "Pawel Pawlowski" <ppawlow(at)poland(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | BUG: triggered data change violation on relation "tbl_b" |
Date: | 2001-08-29 11:00:38 |
Message-ID: | 003201c13079$d7f26e50$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"
Roger Waters w Polsce!
http://ton.poland.com
From | Date | Subject | |
---|---|---|---|
Next Message | Pawel Pawlowski | 2001-08-29 11:18:02 | PD: triggered data change violation on relation "tbl_b" |
Previous Message | Bruce Momjian | 2001-08-29 05:26:59 | Re: Bug #429: Concurrent JDBC connections to result in wrong data |