Postgres Pro
Downloads
Home   >   mailing lists

Composite Unique Key - Doubt - Mailing list pgsql-novice

From Technical Doubts
Subject Composite Unique Key - Doubt
Date
Msg-id CAJyuQsG6C3m846-mPpuipf3mL55KYfRZ-a+QaGZOx9RiGS2WTQ@mail.gmail.com
Whole thread Raw
Responses Re: Composite Unique Key - Doubt
List pgsql-novice
Tree view
Team,

Am using Postgres 9.2

I am having a table

technologies
(
technologyid bigint,
status character(1),
implementeddate date
CONSTRAINT technologies_uq UNIQUE (technologyid, status, implementeddate)
)

entering data as

insert into technologies (technologyid,status,implementeddate)
values
(123,'P',null),
(123,'P',null);

2 rows affected.

table accepting duplicate values in spite of composite unique constraint..
where I am doing wrong?

Thanks in advance.

--
John.

pgsql-novice by date:

Previous
From: LeoTh3o
Date:
Subject: Re: Postgresql iPhone
Next
From: Vibhor Kumar
Date:
Subject: Re: Composite Unique Key - Doubt