Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Marcin MazurekDate: 2000-10-26 06:24:56
Subject: pg_user, changing priviliges
Previous:From: Joel PangDate: 2000-10-25 10:38:06
Subject: disable auto-commit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group