Home > mailing lists

ALTER TABLE - UNIQUE constraint - Mailing list pgsql-admin

From	sreedhar
Subject	ALTER TABLE - UNIQUE constraint
Date	February 21, 2002 06:49:46
Msg-id	00f001c1b85a$39001a40$1201a8c0@lucidindia.net Whole thread Raw
Responses	Strange locking behaviour (Brian McCane <bmccane@mccons.net>)
List	pgsql-admin

Tree view

Hi all,

I am new to PostgreSQL

how can i give the following satement in PostgreSQL

ALTER TABLE tblDayTransaction WITH NOCHECK ADD
  UNIQUE  NON
 (
  empid,
  ppid,
  transdate
 )

regards,
sreedhar

pgsql-admin by date:

From: heatherm@famoice.com
Date: 20 February 2002, 21:10:23
Subject: Re: Postgres Log Rolling

From: Antony Stace
Date: 21 February 2002, 06:54:20
Subject: Locks on Tables

ALTER TABLE - UNIQUE constraint - Mailing list pgsql-admin

Previous

Next