Thread: droping unique constraint

droping unique constraint

From
Marcin Mazurek
Date:
Hi,
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.

tia

ps. list archives are unfortunately unusable...


Marcin Mazurek

--
Kierownik Działu Systemowego
MULTINET SA o/Poznan
http://www.multinet.pl/

Re: droping unique constraint

From
Stephan Szabo
Date:
When the unique constraint was added, it should have
made a unique index on that column.  Removing that index
should remove the unique constraint (you may wish to
make a non-unique index if you have queries that were
using the index)

Stephan Szabo
sszabo@bigpanda.com

On Tue, 24 Oct 2000, Marcin Mazurek wrote:

> Hi,
> 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.
>
> tia
>
> ps. list archives are unfortunately unusable...
>
>
> Marcin Mazurek
>
> --
> Kierownik Dzia�u Systemowego
> MULTINET SA o/Poznan
> http://www.multinet.pl/
>


Re: droping unique constraint

From
Peter Eisentraut
Date:
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/