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 1AE61D1C4EB; Wed, 30 Jul 2003 16:46:33 +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 72215-04; Wed, 30 Jul 2003 13:45:30 -0300 (ADT) Received: from smtp1.mts.net (smtp1.mts.net [205.200.16.74]) by svr1.postgresql.org (Postfix) with ESMTP id D6372D1C4E6; Wed, 30 Jul 2003 13:46:30 -0300 (ADT) Received: from cleartag (wnpgmb01bbz-ac04-p13-242.mts.net [142.161.13.242]) by smtp1.mts.net (8.12.8p1/8.11.3) with SMTP id h6UGjqOq018980; Wed, 30 Jul 2003 11:45:52 -0500 (CDT) Message-ID: <004501c356ba$1a718960$f20da18e@cleartag> From: "George Weaver" To: "Elielson Fontanezi" , "pgsql-general" , "pgsql-sql" References: Subject: Re: [SQL] ALTER TABLE ... DROP CONSTRAINT Date: Wed, 30 Jul 2003 11:45:34 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0042_01C35690.1600B3D0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/17 X-Sequence-Number: 46434 This is a multi-part message in MIME format. ------=_NextPart_000_0042_01C35690.1600B3D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable It works in 7.3.2. George ----- Original Message -----=20 From: Elielson Fontanezi=20 To: pgsql-general ; pgsql-sql=20 Sent: Wednesday, July 30, 2003 10:52 AM Subject: [SQL] ALTER TABLE ... DROP CONSTRAINT Hi all! Who can tell me what postgres version supports ALTER TABLE... DROP CO= NSTRAINT without the need of droping the table to remove a simple coinstraint. (link) >\\\!/< 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 ---------------------------( )----------( )------------------------= -------- \ ( ) / \_/ \_/ ------=_NextPart_000_0042_01C35690.1600B3D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

It works in 7.3.2.

George

----- Original Message -----
Fro= m:=20 Elielson Fontanezi
To: pgsql-general ; pgsql-sql

Sent: Wednesday, July 30, 2003 10:= 52=20 AM

Subject: [SQL] ALTER TABLE ... DRO= P=20 CONSTRAINT

Hi=20 all!

    Who can tell me what postgres version supp= orts=20 ALTER TABLE... DROP CONSTRAINT without

the need=20 of droping the table to remove a simple coinstraint.=20 (link)

   &= nbsp;           &nbs= p;            &= nbsp;     =20 >\\\!/<     55=20 11 5080=20 9283
           = ;            &n= bsp;          =20 !_"""_!     E= lielson=20 Fontanezi
          =             &nb= sp;           =20 (O) (o)     = PRODAM=20 - Technical Support=20 Analyst
-------------------------------oOOO--(_)--OOOo----------------= -------------------
    =20 Success=20 usually comes to those who are too busy to be looking for=20 it.
           =             &nb= sp;   =20 oooo0  &n= bsp;      =20 0oooo
---------------------------(   =20 )----------(   =20 )--------------------------------
      =             &nb= sp;        =20 \ (          &nbs= p;=20 ) =20 /
           &n= bsp;            = ;    =20 \_/           =20 \_/

------=_NextPart_000_0042_01C35690.1600B3D0--