Hi
I have successfully reverse engineered SQL Server databases but when trying to reverse engineer a PostgreSQL database I have the following issues:
The schema screen does not display the schemas
I get the tables but no relationships. I have checked and there are relationships in the database and other tools (dBeaver which is free) are able to reverse engineer them.
Regards
Dennis
Kit.So
February 12, 2018, 8:12am
2
Hi Dennis,
Could you provide the following information?
PostgreSQL version
JDBC driver version
Sample DDL to reproduce the problem
Hi
• I am using PostgreSQL 10.
• JDBC drivers are as shown below
Regards
Dennis
CREATE TABLE public.“Reports” (
“Id” uuid NOT NULL,
“ReportName” text NOT NULL,
“ReportType” int4 NOT NULL,
“ScheduleType” int4 NOT NULL,
“DayOfWeek” int4 NULL,
“DateOfMonth” int4 NULL,
“DataHours” int4 NOT NULL,
“Enabled” bool NOT NULL,
“NextSendDate” timestamp NULL,
“DeletedOn” timestamp NULL,
“AccountId” uuid NOT NULL,
“TimeOfDay” timestamp NOT NULL,
PRIMARY KEY (“Id”)
)
WITH (
OIDS=FALSE
) ;
CREATE TABLE public.“ReportDaysOfWeek” (
“Id” uuid NOT NULL,
“ReportId” uuid NOT NULL,
“DayOfWeek” int4 NOT NULL,
PRIMARY KEY (“Id”),
FOREIGN KEY (“ReportId”) REFERENCES “Reports”(“Id”)
)
WITH (
OIDS=FALSE
) ;
CREATE TABLE public.“ReportRecipients” (
“Id” uuid NOT NULL,
“ReportId” uuid NOT NULL,
“RecipientEmail” text NOT NULL,
“RecipientId” int4 NOT NULL,
PRIMARY KEY (“Id”),
FOREIGN KEY (“ReportId”) REFERENCES “Reports”(“Id”)
)
WITH (
OIDS=FALSE
) ;
Hi,
I have resolved this by updating to all the latest drivers / adapters. It would be great if Visual Paradigm downloaded these by default.
Regards
Dennis
1 Like
Kit.So
February 13, 2018, 1:07am
5
Hi Dennis,
Thank you for your information and suggestion, we’ll do some testing and consider update drivers.
Kit.So
March 13, 2018, 3:13am
6
Hi Dennis,
Sorry for late reply. We’ve tested with default driver version 8.4.703 but cannot reproduce the problem.
But we’ll still consider updating the default drivers.
Kit.So
March 20, 2018, 4:10am
7
Hi Dennis,
We have updated our default JDBC driver to 42.2.2.
1 Like