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