since name of constrauint is in mixed cased u must double quote it in command. below will work.
psql> alter table mytable drop constraint "RI_ConstraintTrigger_17195" restrict ; > I wanted to change a foreign key to be deferrable (db version 7.2.1). During table >creation I > didn't specify a constraint name for the foreign key. > "\d" shows a trigger RI_ConstraintTrigger_17195, however when I'm trying to "alter >table > mytable drop constraint RI_ConstraintTrigger_17195 restrict" I'm getting the error >"constraint > does not exist. > What am I doing wrong here? Or is there another simple solution to switch foreign >keys to be > deferrable? > > Regards > > Egon > > > > ---------------------------(end of broadcast)--------------------------- TIP 2: you >can get off > all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
