From: | snpe <snpe(at)snpe(dot)co(dot)yu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: this is postgresql question..how do i drop unique constraint on a column? |
Date: | 2002-09-09 21:16:39 |
Message-ID: | 200209092316.39077.snpe@snpe.co.yu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
7.3 beta list foreign key with
\d <table_name>
and drop it with
alter table <table_name> drop constraint <constraint_name>
regards
Haris Peco
On Monday 09 September 2002 04:48 pm, Jan Ploski wrote:
> On Fri, Sep 06, 2002 at 03:12:09AM +0000, Eugene Kim wrote:
> > content in content table has unique constraint..(although i can't see it
> > with \d content)
> >
> > how can i drop that constraint?
>
> Eugene,
>
> first, you need to figure out the constraint's name:
>
> select c.relname from pg_class c, pg_index i where
> i.indrelid=(select oid from pg_class where relname='content') and
> c.oid=i.indexrelid and i.indisunique='t';
>
> Then use "drop index <name>" to drop it.
>
> For more info about accessing database metadata, see Developer's Guide,
> chapter "System Catalogs".
>
> -JPL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Bulmer | 2002-09-09 21:30:02 | describe table query? |
Previous Message | snpe | 2002-09-09 21:08:08 | Re: AutoCommit mode in PostgreSQL (7.3 beta1 from CVS 05.09.2002) |