X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id CE916475EEE
	for <pgsql-sql@postgresql.org>; Tue,  1 Apr 2003 13:33:58 -0500 (EST)
Received: from jester.inquent.com (unknown [216.208.117.7])
	by postgresql.org (Postfix) with ESMTP id 1906A47592C
	for <pgsql-sql@postgresql.org>; Tue,  1 Apr 2003 13:33:55 -0500 (EST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by jester.inquent.com (8.12.6/8.12.6) with ESMTP id h31IXwJd017137;
	Tue, 1 Apr 2003 13:33:58 -0500 (EST) (envelope-from rbt@rbt.ca)
Subject: Re: How can I quit this: "Unique " to my table? more info...
From: Rod Taylor <rbt@rbt.ca>
To: Luis Mix <ksql2002@yahoo.com.mx>
Cc: pgsql-sql@postgresql.org,
 Achilleus Mantzios <achill@matrix.gatewaynet.com>
In-Reply-To: <793515575.20030401121712@yahoo.com.mx>
References: <793515575.20030401121712@yahoo.com.mx>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-9bqjviTb3Ar+UATtt9Pq"
Organization: 
Message-Id: <1049222038.35327.95.camel@jester>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.2.2 
Date: 01 Apr 2003 13:33:58 -0500
X-Spam-Status: No, hits=-43.9 required=5.0
	tests=BAYES_10,EMAIL_ATTRIBUTION,HTML_TAG_BALANCE_TABLE,
	IN_REP_TO,PGP_SIGNATURE_2,QUOTED_EMAIL_TEXT,REFERENCES,
	REPLY_WITH_QUOTES,USER_AGENT_XIMIAN autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/13
X-Sequence-Number: 12714

--=-9bqjviTb3Ar+UATtt9Pq
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Tue, 2003-04-01 at 13:17, Luis Mix wrote:
> Hello pgsql-sql,
>=20
> I tried with both, but I obtain the follow Error.
>=20
> ____________________
> >> drop index b_prestamo_no_inventa_idx;
>=20
> ALTER TABLE b_prestamo drop index b_prestamo_no_inventa_idx;
>=20
> ERROR:  parser: parse error at or near "b_prestamo1_no_inventa_idx"

Drop the ALTER TABLE <table>

Just do:
DROP INDEX ...

> --------------------
>=20
> > ALTER TABLE b_prestamo DROP CONSTRAINT b_prestamo_no_inventa_key;

This is 7.3 syntax.


--=20
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

--=-9bqjviTb3Ar+UATtt9Pq
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (FreeBSD)

iD8DBQA+iduV6DETLow6vwwRApk7AJ96Qze8BkwrPR94tUF35atIhIlTsACfSQWH
2SX3/annBhlbK6xFKJSmjwQ=
=rwXO
-----END PGP SIGNATURE-----

--=-9bqjviTb3Ar+UATtt9Pq--