Spotfire Ideas Portal
Add a new idea Subscribe
Status To be Reviewed
Product Spotfire
Categories Information Services
Created by Guest
Created on Apr 16, 2026

RELATED IDEAS

allow to call postgresql function & procedure

One can call postgresql function or procedure using below method from information link


call procedure with?escapeSyntaxCallMode=callIfNoReturn

jdbc:postgresql://<host>:<port>/database?escapeSyntaxCallMode=callIfNoReturn


call function w/o ?escapeSyntaxCallMode=callIfNoReturn

jdbc:postgresql://<host>:<port>/database


however, one can not use the same data source for both. The workaround is to create a seperate data sources for each of them.

as per support, this is not supported yet.

While the JDBC driver includes a setting (escapeSyntaxCallMode=callIfNoReturn) designed to auto-detect the correct mode, it requires the application to signal whether it is calling a function or a procedure and we don't have this.


  • Attach files
The material provided is for informational purposes only, and should not be relied on in making any purchasing or investment decision. The information is not a commitment, promise or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at our sole discretion. © 2026 Cloud Software Group, Inc. All rights reserved