Re: droping unique constraint - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: droping unique constraint
Date
Msg-id Pine.LNX.4.21.0010252229010.790-100000@peter.localdomain
Whole thread Raw
In response to droping unique constraint  (Marcin Mazurek <M.Mazurek@poznan.multinet.pl>)
List pgsql-admin
Marcin Mazurek writes:

> can anybody help me with dropping unique constrint on attribute. I was
> looking for it in pg_attributebut I think this is done in some other way.
> How can I change it without recreating whole table.

Drop the unique index on the column.  Use psql's \d command to find the
name.

> ps. list archives are unfortunately unusable...

Use www.geocrawler.com.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-admin by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: Archives?
Next
From: "Joel Pang"
Date:
Subject: disable auto-commit