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
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
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