From: Rod Taylor <rbt@rbt.ca>
To: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
Cc: pgsql-general <pgsql-general@postgresql.org>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: ALTER TABLE ... DROP CONSTRAINT
Date: 30 Jul 2003 12:21:20 -0400
Message-ID: <1059582079.27770.38.camel@jester> (raw)
In-Reply-To: <A799F7647794D311924A005004ACEA97096997AD@cprodamibs249.prodam>
References: <A799F7647794D311924A005004ACEA97096997AD@cprodamibs249.prodam>
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!
>
> 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
> ---------------------------( )----------(
> )--------------------------------
> \ ( ) /
> \_/ \_/
>
>
>
Attachments:
signature.asc (application/pgp-signature, 186B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rbt@rbt.ca, ElielsonF@prodam.sp.gov.br, pgsql-general@postgresql.org
Subject: Re: ALTER TABLE ... DROP CONSTRAINT
In-Reply-To: <1059582079.27770.38.camel@jester>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox