Recent changes to 200: PostgreSQL Mixed-Case Schema Names Not Quoted in Queries (RowCount)https://sourceforge.net/p/schemaspy/bugs/200/2019-01-17T05:34:47.856000ZRecent changes to 200: PostgreSQL Mixed-Case Schema Names Not Quoted in Queries (RowCount)#200 PostgreSQL Mixed-Case Schema Names Not Quoted in Queries (RowCount)2019-01-17T05:34:47.856000Z2019-01-17T05:34:47.856000ZG_Hosa_Phathttps://sourceforge.net/u/ghosaphat/https://sourceforge.net208d6e3d806848981b3394bbaeff6e6882955bc1<div class="markdown_content"><p>Example from logs:</p>
<div class="codehilite"><pre><span></span>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 Test."Notes" where 0 = 1**
23:22:46.180 WARNING: Table.fetchNumRows - Unable to extract the number of rows for table Notes, using '-1'
23:22:46.180 WARNING: Table.fetchNumRows - org.postgresql.util.PSQLException: ERROR: **relation "test.Notes" does not exist**
Position: 22
</pre></div>
</div>PostgreSQL Mixed-Case Schema Names Not Quoted in Queries (RowCount)2019-01-17T05:10:16.641000Z2019-01-17T05:10:16.641000ZG_Hosa_Phathttps://sourceforge.net/u/ghosaphat/https://sourceforge.netdd4ee665c5d3f52d0b03aabd5751bcce9aaf4266<div class="markdown_content"><p>As stated, when SchemaSpy attempts to get the row count for tables in a schema with a name that has mixed-case characters ("SchemaName" instead of "schemaname"), the query fails and returns a value of -1 for all tables in that schema. Looking at the analysis logs, it appears that the schema name is not enclosed in quotes, whereas the table name is properly quoted.</p></div>