Lucid Export not generating Foreign Keys in PostgreSQL

Question

I am having an issue with my ERD exporting to PostgreSQL. About one-half (8 of 15) FK relationships are not exporting, and ultimately are not created.

How do we verify the connections are made between the two. For instance, I connect the PK of the sub-table to an FK in the primary table visually but, when exporting, that relationship disappears.

When exporting a CSV from my manually created ERD, the relationships appear in the appropriate columns. So, this suggests to me the code export to PostgreSQL is the primary issue.

I have screenshots and the various code documents to send but, would appreciate answers being published here for the next person.

Any help would be appreciated.

Page 1 / 1

Hi @jerryhall, thanks for your post! I am sorry that you are encountering this issue and I’ll be happy to help.

In order for us to have a closer look, could you please share a screenshot of one of the problematic connections on the canvas as well as a snippet of the export where the connection should appear but is not included?

Looking forward to your response!

Reply

Zuzia S · Answer

Hi ​@jerryhall, thanks for your post! I am sorry that you are encountering this issue and I’ll be happy to help.In order for us to have a closer look, could you please share a screenshot of one of the problematic connections on the canvas as well as a snippet of the export where the connection should appear but is not included?Looking forward to your response!

Reply

Create an account in the community

Login with SSO

Log in to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded