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
Re: postgresql generate ddl returns FK with `>()` in it |
| Список | 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 по дате отправления: