Foreign key constraint question

Поиск

Список

Период

Сортировка

От	Perry Smith
Тема	Foreign key constraint question
Дата	20 июля 2007 г. 10:56:39
Msg-id	107462CF-559E-4923-A5EC-40408B7B8737@easesoftware.com обсуждение исходный текст
Ответы	Re: Foreign key constraint question Re: Foreign key constraint question
Список	pgsql-general

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.

Any suggestions?

Thank you,

Low cost SATA Disk Systems for IBMs p5, pSeries, and RS/6000 AIX systems

В списке pgsql-general по дате отправления: