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
signature.asc
Description: Digital signature
