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/
>