Not able to postgresql 11.2 using ODBC connector
Sumit Arora <[email protected]> Thu, 12 Sep 2019 15:49:28 -0700
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <CAESF=MeGm4umKzU0mTF-U+FEfo4BYh_SB2+=T4ANS3p0oBD4iA@mail.gmail.com> |
--000000000000d6befe059262f3e0 Content-Type: text/plain; charset="UTF-8" Hi Postgresql team, I have a PostgreSQL 11.2 database which I need to connect using an ODBC connector to Spotfire Bi tool. System details are as follows: - ODBC driver version : 11.1 - PostgreSQL database version: 11.2 I am getting below error while I am trying to connect: An error occurred in the external data source. External error: ERROR [42703] ERROR: column p.proisagg does not exist; Error while executing the query Thinking it might be issue with driver and ODBC version, I setup a postgresql 11.1 and then also got the same error. Also on your website I don't see ODBC connector for 11.2. Please let me know when that be available. -- Regards, Sumit Arora 805-410-0076 --000000000000d6befe059262f3e0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">Hi Postgresql team,<br clear=3D"all"><div><br></div><div>I= have a PostgreSQL 11.2 database which I need to connect using an ODBC conn= ector to Spotfire Bi tool.<br></div><div>System details are as follows:</di= v><div><ul style=3D"color:rgb(0,0,0);font-family:"Times New Roman"= ;;font-size:medium"><li>ODBC driver version : 11.1</li><li>PostgreSQL datab= ase version: 11.2</li></ul></div><div>I am getting below error while I am t= rying to connect:</div><div><br>=C2=A0An error occurred in the external dat= a source.</div><font color=3D"#ff0000">External error:<br>ERROR [42703] ERR= OR: column p.proisagg does not exist;<br>Error while executing the query</f= ont><div><br></div><div>Thinking it might be issue with driver and ODBC ver= sion, I setup a postgresql 11.1 and then also got the same=C2=A0error.</div= ><div><br></div><div>Also on your website I don't see ODBC connector fo= r 11.2. Please let me know when that be available.</div><div><br></div><div= ><br></div><div><br></div>-- <br><div dir=3D"ltr" class=3D"gmail_signature"= data-smartmail=3D"gmail_signature"><div dir=3D"ltr">Regards,<div>Sumit Aro= ra</div><div>805-410-0076</div></div></div></div> --000000000000d6befe059262f3e0--