Postgres Pro
Downloads
Home   >   mailing lists

How can I Delete/Alter Unique Constraint - Mailing list pgsql-admin

From shreedhar
Subject How can I Delete/Alter Unique Constraint
Date
Msg-id 002701c24f2f$9037fa00$1201a8c0@a4005
Whole thread Raw
Responses Re: How can I Delete/Alter Unique Constraint  (Bhuvan A <bhuvansql@linuxfreemail.com>)
List pgsql-admin
Tree view 
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@lucidindia.net

pgsql-admin by date:

Previous
From: nikolaus@dilger.cc
Date:
Subject: Re: ProstGreSQL on RAID Question
Next
From: Bhuvan A
Date:
Subject: Re: How can I Delete/Alter Unique Constraint