Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

No ERD is generated when connecting to a Postgres database #13

Closed
xinix opened this issue Feb 27, 2018 · 7 comments
Closed

No ERD is generated when connecting to a Postgres database #13

xinix opened this issue Feb 27, 2018 · 7 comments
Assignees

Comments

@xinix
Copy link

xinix commented Feb 27, 2018

I'm trying to generate an ERD of a postgres database. I am running a vagrant box (homestead) with a postgres database, that has some tables in it. When I generate the data model, two messages appear: ER Data Model generation has been started. Please wait... and ER Data Model generation has been finished. In the model explorer an item was added with a database icon, but no tables or ERD schema was generated.

I'm running StarUML 2.8.1 on Windows and version 0.2.1 of this extension.

@korridor
Copy link

korridor commented Mar 4, 2018

I have the same problem on macOS Sierra with MySQL.
I also have StarUML 2.8.1, the messages are the same and I also get an empty database icon.

@einsty
Copy link

einsty commented Mar 22, 2018

I too am seeing a similar issue with macOS Sierra and SQL Server.

@kkrisz1
Copy link
Owner

kkrisz1 commented Apr 6, 2018

If you are using MySQL, make sure you do not change "Database" preference. It has to be "def".
Database means "TABLE_CATALOG"
Database Schema means "TABLE_SCHEMA"
macossierra_mysql_schemainfo

I know that it is a bit confusing, I will fix it later

@kkrisz1
Copy link
Owner

kkrisz1 commented Apr 6, 2018

Please let me know If the above comment solve the problem

@sekanitembo
Copy link

I'm running into this on Win10/SQL Server. I can't seem to find a combination of database/database schema that will read.

I was able to get a separate postgres db (docker container) to work by providing database schema 'public' and then relevant db name, making sure to use the host's port, not the container's.

@kkrisz1
Copy link
Owner

kkrisz1 commented Apr 8, 2018

FYI

PostgreSQL: Documentation

5.8.2. The Public Schema

In the previous sections we created tables without specifying any schema names. By default such tables (and other objects) are automatically put into a schema named “public”. Every new database contains such a schema. Thus, the following are equivalent:

CREATE TABLE products ( ... );
and:

CREATE TABLE public.products ( ... );

@korridor
Copy link

korridor commented Apr 9, 2018

@kkrisz1 Thanks it's working now!

@kkrisz1 kkrisz1 closed this as completed Apr 9, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

5 participants