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:

https://stackoverflow.com/questions/72898296/what-is-in-postgresql-ddl

Regards,
Roman

Reply via email to