From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
Cc: pgsql-general <pgsql-general@postgresql.org>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: [SQL] ALTER TABLE ... DROP CONSTRAINT
Date: Thu, 31 Jul 2003 00:55:18 +0530
Message-ID: <3F281B9E.1050804@trade-india.com> (raw)
In-Reply-To: <A799F7647794D311924A005004ACEA97096997AD@cprodamibs249.prodam>
References: <A799F7647794D311924A005004ACEA97096997AD@cprodamibs249.prodam>
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
> ---------------------------( )----------(
> )--------------------------------
> \ ( ) /
> \_/ \_/
>
>
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: mallah@trade-india.com, ElielsonF@prodam.sp.gov.br, pgsql-general@postgresql.org
Subject: Re: [SQL] ALTER TABLE ... DROP CONSTRAINT
In-Reply-To: <3F281B9E.1050804@trade-india.com>
* 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