[ADMIN] Composite Unique Key - Doubt

2013-06-20 Thread Technical Doubts
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 (12

Re: [ADMIN] Composite Unique Key - Doubt

2013-06-20 Thread Emre Hasegeli
On Thu, 20 Jun 2013 10:42:37 +0300, Technical Doubts wrote: 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 inse

Re: [ADMIN] Composite Unique Key - Doubt

2013-06-20 Thread Thomas Kellerer
Technical Doubts wrote on 20.06.2013 09:42: 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'