Re: delete cascade not working

[Joshua Tolley <eggyknap@xxxxxxxxx>]

On Sat, Apr 25, 2009 at 04:01:20PM -0400, Kenneth Tilton wrote:
> Given constraint:
>
> ALTER TABLE provider_input.common
>   ADD CONSTRAINT common_pin_file_load_sid_fkey FOREIGN KEY  
> (pin_file_load_sid)
>       REFERENCES provider_input.file_load (sid) MATCH FULL
>       ON UPDATE NO ACTION ON DELETE CASCADE;

<snip>

> I do not actually instantiate common, I have a table that inherits from  
> that. I will play around now to see if that is an issue, thought I'd  
> send up a flare here at the same time.

First guess: the foreign key constraint needs to exist on the child
table; having the key on the parent means nothing for the child table.

- Josh / eggyknap

Attachment: signature.asc
Description: Digital signature