| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Marcin Mazurek <M(dot)Mazurek(at)poznan(dot)multinet(dot)pl> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: droping unique constraint |
| Date: | 2000-10-24 23:33:25 |
| Message-ID: | Pine.BSF.4.10.10010241632230.18240-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)bigpanda(dot)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 Dziau Systemowego
> MULTINET SA o/Poznan
> http://www.multinet.pl/
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dk smith | 2000-10-25 01:40:07 | Archives? |
| Previous Message | Gavin M. Roy | 2000-10-24 20:22:46 | Re: Slow Performance |