Artem Tomyuk wrote: > I have a table with unique index with 2 exactly the same rows. > How it can be possible? > > > CREATE TABLE _inforgchngr6716_test > ( > _nodetref bytea NOT NULL, > _noderref bytea NOT NULL, > _messageno numeric(10,0) > ) > WITH ( > OIDS=FALSE > ); > ALTER TABLE _inforgchngr6716_test > OWNER TO postgres; > > -- Index: _inforg6716_bynodemsg_rn_test > > -- DROP INDEX _inforg6716_bynodemsg_rn_test; > > CREATE UNIQUE INDEX _inforg6716_bynodemsg_rn_test > ON _inforgchngr6716_test > USING btree > (_nodetref, _noderref, _messageno); Maybe index corruption. Did you have any crashes? Do you get an error when you REINDEX INDEX _inforg6716_bynodemsg_rn_test; Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
