Re: [ADMIN] droping unique constraint

[Peter Eisentraut]

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      [EMAIL PROTECTED]       http://yi.org/peter-e/