Re: Insert in table with UNIQUE index

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'Artem Tomyuk *EXTERN*'" <admin(at)leboutique(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Insert in table with UNIQUE index
Date: 2016-01-27 14:12:55
Message-ID: A737B7A37273E048B164557ADEF4A58B537D9AF2@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Thorsten Schöning 2016-01-27 14:33:53 Re: Per thread Connection memory
Previous Message Artem Tomyuk 2016-01-27 13:30:49 Insert in table with UNIQUE index