G_Hosa_Phat

Example from logs (redacted): java -jar "<PATH>\schemaSpy.jar" -t pgsql -host <SERVERNAME>:<PORT> -u <USERNAME> -p <PASSWORD> -db <DBNAME> -all -noviews -ahic -dp "<PATH>\postgresql-42.1.4.jar" -gv "C:\Program Files (x86)\Graphviz2.38" -hq -o "C:\SchemaSpy\" 23:22:45.116 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: org.postgresql.util.PSQLException: ERROR: relation "test.Notes" does not exist Position: 15 23:22:45.116 WARNING: Table.initColumnAutoUpdate - SQL:...

Example from logs (redacted): java -jar "<PATH>\schemaSpy.jar" -t pgsql -host <SERVERNAME>:<PORT> -u <USERNAME> -p <PASSWORD> -db <DBNAME> -all -noviews -ahic -dp "<PATH>\postgresql-42.1.4.jar" -gv "C:\Program Files (x86)\Graphviz2.38" -hq -o "C:\SchemaSpy\" 23:22:45.116 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: org.postgresql.util.PSQLException: ERROR: relation "test.Notes" does not exist Position: 15 23:22:45.116 WARNING: Table.initColumnAutoUpdate - SQL:...

Example from logs (redacted): java -jar "<PATH>\schemaSpy.jar" -t pgsql -host <SERVERNAME>:<PORT> -u <USERNAME> -p <PASSWORD> -db <DBNAME> -all -noviews -ahic -dp "<PATH>\postgresql-42.1.4.jar" -gv "C:\Program Files (x86)\Graphviz2.38" -hq -o "C:\SchemaSpy\" 23:22:45.116 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: org.postgresql.util.PSQLException: ERROR: relation "test.Notes" does not exist Position: 15 23:22:45.116 WARNING: Table.initColumnAutoUpdate - SQL:...

Example from logs: java -jar "<PATH>\schemaSpy.jar" -t pgsql -host <SERVERNAME>:<PORT> -u <USERNAME> -p <PASSWORD> -db <DBNAME> -all -noviews -ahic -dp "<PATH>\postgresql-42.1.4.jar" -gv "C:\Program Files (x86)\Graphviz2.38" -hq -o "C:\SchemaSpy\" 23:22:45.116 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: org.postgresql.util.PSQLException: ERROR: relation "test.Notes" does not exist Position: 15 23:22:45.116 WARNING: Table.initColumnAutoUpdate - SQL: select * from...

Example from logs: java -jar "<PATH>\schemaSpy.jar" -t pgsql -host <SERVERNAME>:<PORT> -u <USERNAME> -p <PASSWORD> -db <DBNAME> -all -noviews -ahic -dp "<PATH>\postgresql-42.1.4.jar" -gv "C:\Program Files (x86)\Graphviz2.38" -hq -o "C:\SchemaSpy\" 23:22:45.116 WARNING: Table.initColumnAutoUpdate - Failed to determine auto increment status: org.postgresql.util.PSQLException: ERROR: **relation "test.Notes" does not exist** Position: 15 23:22:45.116 WARNING: Table.initColumnAutoUpdate - SQL: **select...

PostgreSQL Mixed-Case Schema Names Not Quoted in Queries (RowCount)

I just recently ran across SchemaSpy as I'm working on rebuilding my PostgreSQL database structure. After a couple of initial mishaps with basic configuration and figuring out how to format the CLI command, I've been able to produce a great diagram of my new database. However, I noted that all of the tables listed in my analysis report are showing a value of "-1" in the Rows column. Going back through the command line output, I noted a number of lines that say: 13:10:23.523 WARNING: Table.fetchNumRows...

I just recently ran across SchemaSpy as I'm working on rebuilding my PostgreSQL database structure. After a couple of initial mishaps with basic configuration and figuring out how to format the CLI command, I've been able to produce a great diagram of my new database. However, I noted that all of the tables listed in my analysis report are showing a value of "-1" in the Rows column. Going back through the command line output, I noted a number of lines that say: 13:10:23.523 WARNING: Table.fetchNumRows...