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
Дата: