this is postgresql question..how do i drop unique constraint on a column?
content in content table has unique constraint..(although i can't see it
with \d content)
how can i drop that constraint?
thank you
mydb=# \d content
Table "content"
Attribute | Type | Modifier
-----------------+---------+----------
content_id | integer | not null
content | text | not null
title | text |
description | text |
content_type_id | integer | not null
Indices: content_content_key,
content_pkey
mydb=#
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
Import Notes
Resolved by subject fallback
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
Show quoted text
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@postgresql.org so that your
message can get through to the mailing list cleanly