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 382CED1C4D0; Wed, 30 Jul 2003 16:25:44 +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 70024-04; Wed, 30 Jul 2003 13:24:41 -0300 (ADT) Received: from utahisp.com (mail.cyber-wire.com [66.239.12.3]) by svr1.postgresql.org (Postfix) with ESMTP id 9DCE9D1C4B7; Wed, 30 Jul 2003 13:25:41 -0300 (ADT) Received: from chad [63.230.8.76] by utahisp.com (SMTPD32-8.01) id A15C526501B2; Wed, 30 Jul 2003 10:25:00 -0600 Message-ID: <001b01c356b7$3791c5d0$32021aac@chad> From: "Chad Thompson" To: "pgsql-general" , "pgsql-sql" References: Subject: Re: [SQL] ALTER TABLE ... DROP CONSTRAINT Date: Wed, 30 Jul 2003 10:25:39 -0600 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0018_01C35684.EC59DD50" 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-Declude-Sender: chad@weblinkservices.com [63.230.8.76] X-Declude-Spoolname: Df15c526501b2a477.SMD X-Note: This E-mail was scanned by Declude JunkMail (www.declude.com) for spam. X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=HTML_50_60, HTML_FONT_FACE_ODD, REFERENCES, SMTPD_IN_RCVD X-Spam-Level: * X-Archive-Number: 200308/9 X-Sequence-Number: 46426 This is a multi-part message in MIME format. ------=_NextPart_000_0018_01C35684.EC59DD50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 ---------------------------( )----------( )------------------------= -------- \ ( ) / \_/ \_/ =20 7.3 supports the drop constraint. The only exception begin if you upgraded= your database. It keeps the existing trigger like constraints if youve mo= ved from 7.1 or 7.2. But these triggers can be dropped as well. HTH Chad P.S. Great signature! :-) ------=_NextPart_000_0018_01C35684.EC59DD50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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 \_/

7.3 supports the drop constraint= . The=20 only exception begin if you upgraded your database. It keeps the exis= ting=20 trigger like constraints if youve moved from 7.1 or 7.2. But these=20 triggers can be dropped as well.

HTH
Chad

P.S. Great signature!=20 :-)

------=_NextPart_000_0018_01C35684.EC59DD50--