Postgres Pro
Downloads
Home   >   mailing lists

Insert in table with UNIQUE index - Mailing list pgsql-admin

From Artem Tomyuk
Subject Insert in table with UNIQUE index
Date
Msg-id CANYYVqKwbPTj8JHS1MqYVnXzVtAr25bO+eEBWceCz2npoW0Vbg@mail.gmail.com
Whole thread Raw
Responses Re: Insert in table with UNIQUE index  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: Insert in table with UNIQUE index  (bricklen <bricklen@gmail.com>)
List pgsql-admin
Tree view
Hi All!

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);





pgsql-admin by date:

Previous
From: Ankur Kaushik
Date:
Subject: Re: Per thread Connection memory
Next
From: Albe Laurenz
Date:
Subject: Re: Insert in table with UNIQUE index