Re: droping unique constraint

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
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-25 20:29:40
Message-ID: Pine.LNX.4.21.0010252229010.790-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmx(dot)net http://yi.org/peter-e/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Marcin Mazurek 2000-10-26 06:24:56 pg_user, changing priviliges
Previous Message Joel Pang 2000-10-25 10:38:06 disable auto-commit