On Fri, 10 Mar 2017, Brian Dunavant wrote:
I believe the following test should answer your question.
Thank you, Brian. It does answer my question.
Regards,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgres
I believe the following test should answer your question.
db=# create table test ( a integer not null unique );
CREATE TABLE
db=# insert into test values (1);
INSERT 0 1
db=# insert into test values (1);
ERROR: duplicate key value violates unique constraint "test_a_key"
DETAIL: Key (a)=(1) alr
