On Wed, Mar 08, 2006 at 04:06:55PM -0600, Jim Nasby wrote: > On Mar 7, 2006, at 4:42 PM, [EMAIL PROTECTED] wrote: > > >On Tue, Mar 07, 2006 at 05:36:37PM -0500, Tom Lane wrote: > >>[EMAIL PROTECTED] writes: > >>> ALTER TABLE A COLUMN AA ADD CONSTRAINT DELETE ON CASCADE > >> > >>You're missing the specification of the foreign key, not to mention > >>spelling the CASCADE clause backwards. Try > >> > >>ALTER TABLE A ADD FOREIGN KEY(AA) REFERENCES B(BB) ON DELETE CASCADE > > > >Got it right in the Subject: and my many attempts, just not in the > >body :-) > > > >The column already had the foreign key, I never thought to add it > >again. I was only thinking of modifying the minimum necessary. > > Yeah, unfortunately there's no support for modifying constraints.
Well, except in the sense of dropping and re-creating them inside a transaction :) Cheers, D (transactional DDL is fantastic :) -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly