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