X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP
	id C284CD1C4B7; Wed, 30 Jul 2003 16:20:37 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024)
	with ESMTP id 71136-01; Wed, 30 Jul 2003 13:19:35 -0300 (ADT)
Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106])
	by svr1.postgresql.org (Postfix) with ESMTP
	id F16E3D1C4D5; Wed, 30 Jul 2003 13:20:35 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by mailav.tor1.inquent.com (Postfix) with ESMTP
	id 49D3610259; Wed, 30 Jul 2003 12:13:23 -0400 (EDT)
Received: from [10.0.2.9] (unknown [10.0.2.9])
	by mailav.tor1.inquent.com (Postfix) with ESMTP
	id 5797410248; Wed, 30 Jul 2003 12:13:21 -0400 (EDT)
Subject: Re: ALTER TABLE ... DROP CONSTRAINT
From: Rod Taylor <rbt@rbt.ca>
To: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
Cc: pgsql-general <pgsql-general@postgresql.org>,
	pgsql-sql <pgsql-sql@postgresql.org>
In-Reply-To: <A799F7647794D311924A005004ACEA97096997AD@cprodamibs249.prodam>
References: <A799F7647794D311924A005004ACEA97096997AD@cprodamibs249.prodam>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-SbqzwWHlHxRXE70uMmo8"
Message-Id: <1059582079.27770.38.camel@jester>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.3 
Date: 30 Jul 2003 12:21:20 -0400
X-Virus-Scanned: by AMaViS perl-11
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/1471
X-Sequence-Number: 46324

--=-SbqzwWHlHxRXE70uMmo8
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

I think you can do some constraints in 7.2, but 7.3 will allow dropping
them all in that fashion.

On Wed, 2003-07-30 at 11:52, Elielson Fontanezi wrote:
> Hi all!
>=20=20
>     Who can tell me what postgres version supports ALTER TABLE... DROP
> CONSTRAINT without
> the need of droping the table to remove a simple coinstraint. (link)
>=20
>                                    >\\\!/<     55 11 5080 9283
>                                    !_"""_!     Elielson Fontanezi
>                                    (O) (o)     PRODAM - Technical
> Support Analyst
> -------------------------------oOOO--(_)--OOOo---------------------------=
--------
>      Success usually comes to those who are too busy to be looking for
> it.
>                             oooo0          0oooo
> ---------------------------(    )----------(=20=20=20
> )--------------------------------
>                             \  (            )  /
>                              \_/            \_/
>=20
>=20
>=20=20

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

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

iD8DBQA/J/B/6DETLow6vwwRAv53AJ471M/xyIawZ8Z4ys9KtjJ4OK6KWgCfduUR
MFfcC+4mCfczDzZ+6w3npeE=
=C9m3
-----END PGP SIGNATURE-----

--=-SbqzwWHlHxRXE70uMmo8--