Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-odbc-owner+archive@lists.postgresql.org>)
	id 1r7wfq-007aQw-L3
	for pgsql-odbc@arkaria.postgresql.org; Tue, 28 Nov 2023 11:54:42 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-odbc-owner+archive@lists.postgresql.org>)
	id 1r7wfp-004dY4-BA
	for pgsql-odbc@arkaria.postgresql.org; Tue, 28 Nov 2023 11:54:41 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <davecramer@postgres.rocks>)
	id 1r7wfp-004dXs-3g
	for pgsql-odbc@lists.postgresql.org; Tue, 28 Nov 2023 11:54:41 +0000
Received: from pgintl.fastcrypt.com ([149.56.129.164])
	by magus.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <davecramer@postgres.rocks>)
	id 1r7wfj-008xj0-V6
	for pgsql-odbc@postgresql.org; Tue, 28 Nov 2023 11:54:40 +0000
Received: from mail-lf1-f52.google.com (mail-lf1-f52.google.com
 [209.85.167.52])
	by pgintl.fastcrypt.com (Postfix) with ESMTPSA id 8F19B202C1
	for <pgsql-odbc@postgresql.org>; Tue, 28 Nov 2023 06:54:33 -0500 (EST)
Received: by mail-lf1-f52.google.com with SMTP id
 2adb3069b0e04-50bb83d9e17so997870e87.0
        for <pgsql-odbc@postgresql.org>; Tue, 28 Nov 2023 03:54:33 -0800 (PST)
X-Gm-Message-State: AOJu0YwJDVFUwS+YXygKpmrudhJYst2nbH/r7eTmE3XYybn5933VlFN7
	cmsnRJV+70DaVkfEfrG3Joycaz2QcEy04YVbe5U=
X-Google-Smtp-Source: 
 AGHT+IFx8GffGWyMy45xPq2d4hDO8i4Eb6f25OTjyukVgM4QZ+siXqDsxfgmpSqECbeIidSc6xqQfg8ztBGql2/7fgw=
X-Received: by 2002:a05:6512:3e0f:b0:50b:c014:3b69 with SMTP id
 i15-20020a0565123e0f00b0050bc0143b69mr616232lfv.34.1701172472130; Tue, 28 Nov
 2023 03:54:32 -0800 (PST)
MIME-Version: 1.0
References: 
 <CANZL2iFKPR=uQB2jt99a4o+2A4RrzmPVmrwY+JLKE3iJ2Yq2cg@mail.gmail.com>
In-Reply-To: 
 <CANZL2iFKPR=uQB2jt99a4o+2A4RrzmPVmrwY+JLKE3iJ2Yq2cg@mail.gmail.com>
From: Dave Cramer <davecramer@postgres.rocks>
Date: Tue, 28 Nov 2023 06:54:14 -0500
X-Gmail-Original-Message-ID: 
 <CADK3HH+UBj4hvS2iV5OFZvdf3BWb8p4J8aHoop7gXGdMd3fLKg@mail.gmail.com>
Message-ID: 
 <CADK3HH+UBj4hvS2iV5OFZvdf3BWb8p4J8aHoop7gXGdMd3fLKg@mail.gmail.com>
Subject: Re: Issue with the existing psqlodbc version of upgraded instance
To: Chirag Karkera <chiragkrkr102@gmail.com>
Cc: pgsql-odbc@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e730c5060b3514e9"
List-Id: <pgsql-odbc.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-odbc@lists.postgresql.org>
List-Owner: <mailto:pgsql-odbc-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-odbc>
Archived-At: 
 <https://www.postgresql.org/message-id/CADK3HH%2BUBj4hvS2iV5OFZvdf3BWb8p4J8aHoop7gXGdMd3fLKg%40mail.gmail.com>
Precedence: bulk

--000000000000e730c5060b3514e9
Content-Type: text/plain; charset="UTF-8"

Hi Chirag,




On Tue, 28 Nov 2023 at 03:19, Chirag Karkera <chiragkrkr102@gmail.com>
wrote:

> Hi Team,
>
> We have upgraded the RDS database version from v13.10 to v15.4
>
> The current odbc version we are using is below,
> Name        : postgresql-odbc
> Version     : 09.03.0100
> Release     : 2.el7
> Architecture: x86_64
>
> Do we have any specific matrix where we can check the compatibility issue.
>

09.03.0100 is almost 10 years old PostgreSQL: File Browser
<https://www.postgresql.org/ftp/odbc/versions/dll/>

While we don't have a compatibility matrix generally speaking you should be
using the latest version of the driver. My recommendation is that you
upgrade to at least 15.0 if not 16.0

Regards,
Dave Cramer

>

--000000000000e730c5060b3514e9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">Hi Chir=
ag,<div><br></div><div><br></div><div><div><div dir=3D"ltr" class=3D"gmail_=
signature"><div dir=3D"ltr"><div><br></div></div></div></div></div></div></=
div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On=
 Tue, 28 Nov 2023 at 03:19, Chirag Karkera &lt;<a href=3D"mailto:chiragkrkr=
102@gmail.com">chiragkrkr102@gmail.com</a>&gt; wrote:<br></div><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">Hi =
Team,=C2=A0<div><br></div><div>We have upgraded the RDS database version fr=
om v13.10 to v15.4=C2=A0</div><div><br></div><div>The current odbc version =
we are using is below,=C2=A0</div><div><div>Name=C2=A0 =C2=A0 =C2=A0 =C2=A0=
 : postgresql-odbc</div><div>Version=C2=A0 =C2=A0 =C2=A0: 09.03.0100</div><=
div>Release=C2=A0 =C2=A0 =C2=A0: 2.el7</div><div>Architecture: x86_64</div>=
</div><div><br></div><div>Do we have any specific=C2=A0matrix where we can =
check the compatibility issue.=C2=A0</div></div></div></blockquote><div><br=
></div><div>09.03.0100 is almost 10 years old=C2=A0<a href=3D"https://www.p=
ostgresql.org/ftp/odbc/versions/dll/">PostgreSQL: File Browser</a></div><di=
v><br></div><div>While we don&#39;t have a compatibility matrix generally s=
peaking you should be using the latest version of the driver. My recommenda=
tion is that you upgrade to at least 15.0 if not 16.0</div><div><br></div><=
div>Regards,<br clear=3D"all"></div><div>Dave Cramer</div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">
</blockquote></div></div></div>

--000000000000e730c5060b3514e9--