Re: [SQL] ALTER TABLE ... DROP CONSTRAINT

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