Insert in table with UNIQUE index

From: Artem Tomyuk <admin(at)leboutique(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Insert in table with UNIQUE index
Date: 2016-01-27 13:30:49
Message-ID: CANYYVqKwbPTj8JHS1MqYVnXzVtAr25bO+eEBWceCz2npoW0Vbg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2016-01-27 14:12:55 Re: Insert in table with UNIQUE index
Previous Message Ankur Kaushik 2016-01-27 11:09:30 Re: Per thread Connection memory