Thread: droping unique constraint
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/
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/ >
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/