Re: Foreign key constraint question

On Fri, Jul 20, 2007 at 08:57:25AM -0500, Perry Smith wrote:
> I want to do something like this:
>
> ALTER TABLE companies ADD CONSTRAINT fk_companies_item_id
>              FOREIGN KEY (item_id, 'Company')
>              REFERENCES item_bases(item_id, item_type)
>              INITIALLY DEFERRED
>
> I could add a column to companies that is always set to "Company" but
> that seems like a waste.  I tried the above and I got a syntax error.

What purpose is the constraint intended to achieve?

--
Michael Fuhr