Krzysztof Szymko

TEXtFX * Case operation removes last char

I looked into it more deeply. This is what I found: postgresql-42.2.8.jar under PROCEDURE (procedures and functions) are shown OK postgresql-42.2.9.jar - postgresql-42.2.12.jar: a) no FUNCTIONS are shown under PROCEDURE b) there is no node for FUNCTIONS (only PROCEDURE) After turning log_statement = 'all' on PostgreSQL you can see the difference: -- 42.2.8 SELECT NULL AS PROCEDURE_CAT, n.nspname AS PROCEDURE_SCHEM, p.proname AS PROCEDURE_NAME, NULL, NULL, NULL, d.description AS REMARKS, 2 AS PROCEDURE_TYPE,...

All my tests were done on Win 10 Java class TestPostgreSQL lists procedures as expected from provided schema. Build of SQuirreL from 2020/01/22 still behaves same (buggy) with driver 42.2.9 Switching to 42.2.8 helps and procedures are shown as expected. NOTE: In squirrel log I have found weird logs (maybe this will help): 2020-01-22 21:21:05,250 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.plugin.PluginManager - Failed to load org.postgresql.osgi.PGDataSourceFactory in F:\Tools\squirrel-sql-4.0.0-TDG\plugins\postgres\lib\postgresql-42.2.9.jar...

As a side info I am using PostgreSQL 12.1 on JDK jdk1.8.0_231

Procedures are NOT displayed with PostgreSQL JDBC Driver postgresql-42.2.9.jar

Connections tab shows no data on PostgreSQL 9.2+

Typo on Properties for Alias > Schemas

New SQL Worksheet