From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ian Barwick <barwick@gmx.net>
Cc: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: Luis Mix <ksql2002@yahoo.com.mx>
Cc: pgsql-sql@postgresql.org
Subject: Re: How can I quit this: "Unique " to my table?
Date: Tue, 01 Apr 2003 11:12:42 -0500
Message-ID: <1267.1049213562@sss.pgh.pa.us> (raw)
In-Reply-To: <200304011715.54301.barwick@gmx.net>
References: <Pine.LNX.4.44.0304011725230.23310-100000@matrix.gatewaynet.com>
<200304011715.54301.barwick@gmx.net>
Ian Barwick <barwick@gmx.net> writes:
> On Tuesday 01 April 2003 21:26, Achilleus Mantzios wrote:
>> drop index b_prestamo_no_inventa_idx;
> ALTER TABLE b_prestamo DROP CONSTRAINT b_prestamo_no_inventa_key ??
The correct answer is "one or the other depending on which PG version
he's running" ;-). Before 7.3, drop the index; as of 7.3 you're
supposed to drop the constraint instead. (No harm in trying the wrong
one, it just won't let you do it.)
Looking at the output of psql's "\d b_prestamo" would be a good idea to
verify the spelling of the index and/or constraint name.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, barwick@gmx.net, achill@matrix.gatewaynet.com, ksql2002@yahoo.com.mx
Subject: Re: How can I quit this: "Unique " to my table?
In-Reply-To: <1267.1049213562@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox