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
Список
Дерево обсуждения
postgresql generate ddl returns FK with `<?>()` in it Roman Gavrilov <roman.gavrilov@projectcanary.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>
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
Дата:
От: Tom Lane
Дата:
FAQ