Petko Ditchev Posted January 15, 2019 Share Posted January 15, 2019 I'm trying to connect SpotFire to a PostgreSQL database (ver. 11) . I got the error message: "ERROR [42703] ERROR: column p.proisagg does not exist; Error while executing the query" . I tried versions 9.*, 10.* and 11.* of the ODBC driver, whith the same result. Tested the DB with other services and it works (DBeaver, pgAdmin4). As far as I could figure out removing proisagg was a recent backwards incompatible change in PostgreSQL 11. Reference mailing list discussion: https://www.postgresql.org/message-id/CAFj8pRD8y4CLmMq8zEcNsx8YW27s55yvS... Any advice would be appreciated. i guess I could've missed something. Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted January 18, 2019 Share Posted January 18, 2019 These tools use odbc driver or jdbc driver You can check connection/query with razorsql (https://razorsql.com/) where it has the option to test with odbc driver and select the one which you have installed for spotfire Link to comment Share on other sites More sharing options...
Petko Ditchev Posted January 21, 2019 Author Share Posted January 21, 2019 The ODBC driver, as it's the only option (AFAIK) for connection to PostgreSQL via SpotFire Desktop. I could test my DB and the ODBC driver with razorsql, but it's just a vanilla PostgreSQL database on linux (freshly made), I recon someone has already done that for the realeased versions of the driver. I'm pretty sure it's a bug on the SpotFire side, but I wanted to doublecheck here before posting a ticket. Link to comment Share on other sites More sharing options...
Geetika Saini Posted June 27, 2019 Share Posted June 27, 2019 Hello, did you got the solution for your issue. I am facing the same issue when I trying to connect Spotfire with my local Postgres DB. Your response will be appreciated Link to comment Share on other sites More sharing options...
Richard Gaushell Posted June 27, 2019 Share Posted June 27, 2019 Spotfire X 10.3 is claiming to have PostgreSQL 11 support. I've installed 10.3 but haven't tested PG11 yet. But that is the only path that I know about. Link to comment Share on other sites More sharing options...
Geetika Saini Posted August 20, 2019 Share Posted August 20, 2019 Did anyone help me with this issue as it is not letting me connect with Postgres database. Link to comment Share on other sites More sharing options...
Geetika Saini Posted September 10, 2019 Share Posted September 10, 2019 Has any body found the solution for this I am able to connect the spotfire with cloud based DB but when i try it with local DB ,it is gving this error any solution to resolve this issue Link to comment Share on other sites More sharing options...
Harshith Reddy Musku Posted September 12, 2019 Share Posted September 12, 2019 @geetikasaini30 - What Spotfire version do you use This issue has been addressed in v10.3. You should now be able to connect to Protgres 11 from Spotfire installed client 10.3 and higher versions. Link to comment Share on other sites More sharing options...
Geetika Saini Posted September 12, 2019 Share Posted September 12, 2019 I am able to resolve the issue. It was a version compatibility issue, Spotfire 10.0 does not support Postgres above 10 version I was trying to connect to Postgres 11.0. After switching to Postgres 10.0, I was able to connect to DB. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now