Reverse Engineering PostgreSQL


#1

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


#2

Hi Dennis,

Could you provide the following information?

  • PostgreSQL version
  • JDBC driver version
  • Sample DDL to reproduce the problem

#3

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
) ;


#4

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


#5

Hi Dennis,

Thank you for your information and suggestion, we’ll do some testing and consider update drivers.


#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.


#7

Hi Dennis,

We have updated our default JDBC driver to 42.2.2.