beta 2 crash with unique constraints - Mailing list pgsql-hackers

Hi List, I have another error now here:

notice that only one backend is dying, all others are up and working.

Error - Message :

duplicate key violates unique constraint "ferber_rust_params_pkey"
FATAL:  block 0 of 1663/19335/476756 is still referenced (local 2)
server closed the connection unexpectedlyThis probably means the server terminated abnormallybefore or while


here is a sample script causing this server-crash (simple cut and paste)

BEGIN;

CREATE SEQUENCE dbridseq;
 CREATE TABLE ferber_rust_params  (fbrp_id        SERIAL PRIMARY KEY,   fbrp_pos        INTEGER,
fbrp_ferber       VARCHAR(20),   fbrp_descr        VARCHAR(80) NOT NULL,   fbrp_name        VARCHAR(10) NOT NULL,
fbrp_default       FLOAT4,   fbrp_formula        VARCHAR(100),   dbrid        VARCHAR UNIQUE DEFAULT
nextval('dbridseq') );
 


INSERT INTO ferber_rust_params (fbrp_id, fbrp_pos, fbrp_ferber, 
fbrp_descr, fbrp_name, fbrp_default, fbrp_formula, dbrid) VALUES (6, 4, 
'BSRUND', 'Vorschub aus Tabelle', 'vorschub', 360, 
'vorschub-(vorschub/100*40)', '337941');


SELECT * INTO TEMP TABLE ferber_rus_205102 FROM ferber_rust_params WHERE 
fbrp_ferber='BSRUND';
UPDATE ferber_rus_205102 SET fbrp_name='BSRUND1';
ALTER TABLE ferber_rus_205102 DROP COLUMN dbrid;
INSERT INTO ferber_rust_params SELECT * FROM ferber_rus_205102;

ROLLBACK;

PS : Running Windows XP Home.


Daniel
BEGIN;

CREATE SEQUENCE dbridseq;
CREATE TABLE ferber_rust_params (fbrp_id        SERIAL PRIMARY KEY,  fbrp_pos        INTEGER,            fbrp_ferber
   VARCHAR(20), --REFERENCES ferber ON UPDATE CASCADE ON DELETE CASCADE,  fbrp_descr        VARCHAR(80) NOT NULL,
fbrp_name       VARCHAR(10) NOT NULL,  fbrp_default        FLOAT4,  fbrp_formula        VARCHAR(100),  dbrid
VARCHARUNIQUE DEFAULT nextval('dbridseq') );
 


INSERT INTO ferber_rust_params (fbrp_id, fbrp_pos, fbrp_ferber, fbrp_descr, fbrp_name, fbrp_default, fbrp_formula,
dbrid)VALUES (6, 4, 'BSRUND', 'Vorschub aus Tabelle', 'vorschub', 360, 'vorschub-(vorschub/100*40)', '337941');
 


SELECT * INTO TEMP TABLE ferber_rus_205102 FROM ferber_rust_params WHERE fbrp_ferber='BSRUND';
UPDATE ferber_rus_205102 SET fbrp_name='BSRUND1';
ALTER TABLE ferber_rus_205102 DROP COLUMN dbrid;
INSERT INTO ferber_rust_params SELECT * FROM ferber_rus_205102;

ROLLBACK;