From ElielsonF@prodam.sp.gov.br Wed Jul 30 15:50:35 2003 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 97130D1C4D0; Wed, 30 Jul 2003 15:50:35 +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 68209-04; Wed, 30 Jul 2003 12:49:32 -0300 (ADT) Received: from sampa7.prodam.sp.gov.br (unknown [200.230.190.107]) by svr1.postgresql.org (Postfix) with ESMTP id 0754BD1C4C9; Wed, 30 Jul 2003 12:50:28 -0300 (ADT) Received: from cprodamibs249.PRODAM (cprodamibs249.prodam.sp.gov.br [10.10.64.249]) by sampa7.prodam.sp.gov.br with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id PTQ3W27X; Thu, 31 Jul 2003 12:50:29 -0300 Received: by cprodamibs249.prodam with Internet Mail Service (5.5.2653.19) id ; Wed, 30 Jul 2003 12:52:10 -0300 Message-ID: From: Elielson Fontanezi To: pgsql-general , pgsql-sql Subject: ALTER TABLE ... DROP CONSTRAINT Date: Wed, 30 Jul 2003 12:52:09 -0300 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C356B1.FC068D16" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=HTML_50_60, HTML_FONT_FACE_ODD, SUBJ_ALL_CAPS X-Spam-Level: X-Archive-Number: 200307/1468 X-Sequence-Number: 46321 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C356B1.FC068D16 Content-Type: text/plain; charset="iso-8859-1" Hi all! 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) >\\\!/< 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_001_01C356B1.FC068D16 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

= Hi=20 all!

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

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

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

------_=_NextPart_001_01C356B1.FC068D16-- From andrewgould@yahoo.com Wed Jul 30 16:07:12 2003 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 8EC85D1C4D6 for ; Wed, 30 Jul 2003 16:07:12 +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 68258-10 for ; Wed, 30 Jul 2003 13:06:09 -0300 (ADT) Received: from web13402.mail.yahoo.com (web13402.mail.yahoo.com [216.136.175.60]) by svr1.postgresql.org (Postfix) with SMTP id 2F0E3D1C4D0 for ; Wed, 30 Jul 2003 13:07:10 -0300 (ADT) Message-ID: <20030730160709.22226.qmail@web13402.mail.yahoo.com> Received: from [24.204.21.207] by web13402.mail.yahoo.com via HTTP; Wed, 30 Jul 2003 09:07:09 PDT Date: Wed, 30 Jul 2003 09:07:09 -0700 (PDT) From: Andrew Gould Subject: Re: ALTER TABLE ... DROP CONSTRAINT To: Elielson Fontanezi , pgsql-general , pgsql-sql In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/1469 X-Sequence-Number: 46322 --- Elielson Fontanezi wrote: > Hi all! > > 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) > > Elielson Fontanezi > PRODAM - Technical Support > Analyst I performed that task yesterday using PostgreSQL 7.3.3: Alter table mkt drop constraint mkt_pkey; I don't know if it's supported in earlier versions. Best regards, Andrew Gould From rbt@rbt.ca Wed Jul 30 16:20:37 2003 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 To: Elielson Fontanezi Cc: pgsql-general , pgsql-sql In-Reply-To: References: 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-- From chad@weblinkservices.com Wed Jul 30 16:25:44 2003 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-- From georgew1@mts.net Wed Jul 30 16:46:33 2003 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-- From mallah@trade-india.com Wed Jul 30 19:25:19 2003 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 90A38D1C4D5 for ; Wed, 30 Jul 2003 19:25:19 +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 81257-06 for ; Wed, 30 Jul 2003 16:24:17 -0300 (ADT) Received: from trade-india.com (ns5.trade-india.com [66.234.10.13]) by svr1.postgresql.org (Postfix) with SMTP id 746B1D1C995 for ; Wed, 30 Jul 2003 16:25:12 -0300 (ADT) Received: (qmail 11035 invoked by uid 0); 30 Jul 2003 19:24:38 -0000 Received: from mallah@trade-india.com by ns5.trade-india.com by uid 502 with qmail-scanner-1.15 (uvscan: v4.1.60/v4171. Clear:. Processed in 0.944065 secs); 30 Jul 2003 19:24:38 -0000 Received: from unknown (HELO trade-india.com) (203.145.130.142) by ns5.trade-india.com with SMTP; 30 Jul 2003 19:24:37 -0000 Message-ID: <3F281B9E.1050804@trade-india.com> Date: Thu, 31 Jul 2003 00:55:18 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030701 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Elielson Fontanezi Cc: pgsql-general , pgsql-sql Subject: Re: [SQL] ALTER TABLE ... DROP CONSTRAINT References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/1486 X-Sequence-Number: 46339 if the constraint are named $1 $2 etc you will need to quote them eg ALTER TABLE xyz DROP CONSTRAINT "$1" ; in some version you may require ALTER TABLE xyz DROP CONSTRAINT "$1" RESTRICT; What is ur version btw? try to post the table structure also. regds mallah. Elielson Fontanezi wrote: > Hi all! > > 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) > > >\\\!/< 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 > ---------------------------( )----------( > )-------------------------------- > \ ( ) / > \_/ \_/ > >