Help->[SQL Log] shows that the query fails because "column current_query" does not exist.
Issue begins in version 9.3, as the catalog table was changed. Looking at code, we currently only had support up to 9.2.
9.3 added -- CREATE MATERIALIZED VIEW DDL & Event Triggers -- Do we want to open a support issue for postgres 9.3 enhancements for this items for version 15? 16? 17? -- created Issue #13126
9.4 added -- jsonb datatype. -- i can add this to 15 and 16 easily with this issue.
made the changes to the process info extraction to handle the catalog table changes. Also made fixes to support the datatypes in GUI and ERM.
made the changes to the process info extraction to handle the catalog table changes. Also made fixes to support the datatypes in GUI and ERM.
Verified in ADS v15.0.14-16. Current Activity -> Process Info doe not give any more exceptions for the Details View. Session information is displayed correctly now
Verified in ADS v15.0.14-16. Current Activity -> Process Info doe not give any more exceptions for the Details View. Session information is displayed correctly now
Issue #13117 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
1 issue link |
relates to #12885
Issue #12885PostgreSQL DBA Tool -> Session Manager gives column current_query not found exception |
Issue begins in version 9.3, as the catalog table was changed. Looking at code, we currently only had support up to 9.2.
9.3 added -- CREATE MATERIALIZED VIEW DDL & Event Triggers -- Do we want to open a support issue for postgres 9.3 enhancements for this items for version 15? 16? 17? -- created Issue #13126
9.4 added -- jsonb datatype. -- i can add this to 15 and 16 easily with this issue.