cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

PostgreSQL - handle postgre version in extension

nicomon
Frequent Guest

Some queries executed by PostgreSQL extension are reporting errors while they are trying to get value from non-existing columns in differents version of PostgreSQL databases.

This behavior generate a huge amount of logs, and create incident on production activity.

it would be better to check the version before and then send proper queries regarding curent version of databases.

It will avoid to generate many logs.

exemple : queries on "total_time" column.

2 REPLIES 2

Mike_L
Dynatrace Guru
Dynatrace Guru

Hi,

 

It is a limitation on our data source, please raise it as a product idea to have our data sources handle conditional queries.

Mike

Peter_Youssef
Champion

Hello @nicomon 

Regarding the raised concern, kindly find the below info:

2024-10-16_17h27_36.png

There is alternative solution: 

2024-10-16_17h38_27.png

In case you have tried all these attempts, then:

  1. Reach out to Dynatrace support team via live chat or raise a support ticket.
  2. Share the detailed scenario, if possible include screenshots and logs with Dynatrace on DynatraceProductIdeas 

KR,

Peter.

 

 

Featured Posts