Redshift Procedures not listed DBExplorer

[sim bush]

As per title, cannot see a node or items for Stored Procedures.

(is a node for 'functions', but this doesn't show any procs.)

Product Name: Redshift
Product Version: 8.0
Product Info: 8.0.2
Driver Name: Redshift JDBC Driver
Driver Class: com.amazon.redshift.Driver
Driver Version: 2.1.0.1
Isolation Level: SERIALIZABLE

SQL Workbench/J
Build 127 (2020-08-22)
Java Version: 1.8.0_211 (64bit)

[Thomas Kellerer]

The list of functions and procedures is obtained through the JDBC driver.
If nothing is shown, this is propbably a problem with the Redshift JDBC driver.
But without the (complete) logfile I can't tell

Thomas

[sim bush]

Opened workbench with the DBTree already filtered to 'Procedures'

at 11:00 i navigated to a specific schema where only a 'functions' node was listed, and right-click > reload

Hope that helps ?

Thanks

(and Happy Christmas!)

[Thomas Kellerer]

I was refering to the SQL Workbench logfile. The logfile from the JDBC driver is not helpful for this.

[RA]

I have the same issue. I installed the latest JDBS Redshift driver, the same as used by dBeaver (which is able to display all objects correctly) but still no SPs are listed.

In filter I checked the PROCEDURE checkbox.

Please let me know how I can collect the required log to help facilitate the solution?

[Thomas Kellerer]

Maybe Dbeaver bypasses the JDBC driver for that.

SQL Workbench/ does not officially support Redshift and has no workarounds implemented for deficiencies in the driver.