Re: ALTER TABLE -- how to add ON DELETE CASCADE?

On Mar 7, 2006, at 4:42 PM, felix(at)crowfix(dot)com wrote:

> On Tue, Mar 07, 2006 at 05:36:37PM -0500, Tom Lane wrote:
>> felix(at)crowfix(dot)com 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.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461