postgresql generate ddl returns FK with `()` in it

Поиск
Список
Период
Сортировка
От Roman Gavrilov
Тема postgresql generate ddl returns FK with `()` in it
Дата
Msg-id CA+FPCaUO=j5bkSLpAOgs8bvt1Jvs=tTwxxmjSM+gis5PNgK=zg@mail.gmail.com
обсуждение исходный текст
Ответы Re: postgresql generate ddl returns FK with `()` in it  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Re: postgresql generate ddl returns FK with `()` in it  (Francisco Olarte <folarte@peoplecall.com>)
Список pgsql-general
I have a schema with two tables, where the first table's composite 2-columns FK points to the second table's 2-columns composite PK. But the order of columns is reversed.

When I use `Generate DDL` on the first table, FK definition comes back as:

ALTER TABLE eval.rubric_questions ADD CONSTRAINT rubric_questions_fk FOREIGN KEY (rubric_id,rubric_version_id) REFERENCES <?>();

How can I fix that `<?>();` issue? Is this documented behavior?

(I realize that I need to fix the schema, but in time-being I need to generate code using entity framework, and it chokes in that).

Full details on SO:


Regards,
Roman

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

Предыдущее
От: Dominique Devienne
Дата:
Сообщение: About revoking large number of privileges; And the PUBLIC role.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: About revoking large number of privileges; And the PUBLIC role.