"CN" <[EMAIL PROTECTED]> writes:
> db1=# update tt1 set remark ='xx';
> ERROR: Cannot insert a duplicate key into unique index tt2_pkey
The attached patch against 7.3 fixes it.
regards, tom lane
*** src/backend/optimizer/prep/prepunion.c.orig Wed Sep 18 17:35:21 2002
---
"CN" <[EMAIL PROTECTED]> writes:
> db1=# update tt1 set remark ='xx';
> ERROR: Cannot insert a duplicate key into unique index tt2_pkey
This example works okay in 7.2.3. I think I broke it in 7.3 while
fixing another problem :-(. Will work on it.
regards, tom lane
Hello! Could you check the following testing results and questions?
Thank you!
CN
CREATE TABLE tt1 (
f1 INTEGER PRIMARY KEY
)WITHOUT OIDS;
CREATE TABLE tt2 (
PRIMARY KEY (f1,f2),
f2 INTEGER,
f3 VARCHAR(80)
)
INHERITS (tt1)
WITHOUT OIDS;
db1=# insert into tt2 values(1,1,'
