How can I Delete/Alter Unique Constraint

From: "shreedhar" <shreedhar(at)lucidindia(dot)net>
To: "Postgres" <pgsql-admin(at)postgresql(dot)org>
Subject: How can I Delete/Alter Unique Constraint
Date: 2002-08-29 07:42:00
Message-ID: 002701c24f2f$9037fa00$1201a8c0@a4005
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

How can I delete Unique Constraint/ Alter Unique Constraint.

example

tblStudent
=======
stdid
stdname
classid

previously I gave stdname as UNIQUE
but I need to alter it as UNIQUE (stdname,classid)

Just it is an example, donot ask why not more than one student with same can
exist in one class.

Thanks alot,

With Best Regards,
Sreedhar Bhaskararaju 1,2nd Main Road, KottuGardens, Chennai - 600 085 Ph :
4475111 Email : shreedhar(at)lucidindia(dot)net

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bhuvan A 2002-08-29 09:57:31 Re: How can I Delete/Alter Unique Constraint
Previous Message nikolaus 2002-08-28 23:31:37 Re: ProstGreSQL on RAID Question