Minor addition.
The catalog tables changed in PostgreSQL 12 I believe e.g. where constraints
are stored.
As such if you are using an older ODBC driver pre PostgreSQL 11 it may or
many not work on newer PostgreSQL servers.
E.g. one big pain point for my customers was Tableau not updating their ODBC
drivers so I had to downgrade one of our PostgreSQL servers to service
Tableau online.
Moral of story - you should try to use an ODBC driver that is at least as
new as your Database server or you might be missing out on functionality or
have broken logic.
Hope that helps,
Regina
> -----Original Message-----
> From: Clemens Ladisch [mailto:clemens@ladisch.de]
> Sent: Wednesday, June 17, 2020 7:41 AM
> To: pgsql-odbc@lists.postgresql.org
> Subject: Re: support policy
>
> Shi, Junjie (Jasper) wrote:
> > What is the support policy of the postgresql odbc driver?
>
> The network protocol has not changed since version 7.4.
> Any ODBC driver version will work with any server version. (Except for new
> features like SCRAM passwords.)
>
>
> Regards,
> Clemens
>
>
> > *Disclaimer*
>
> *** DISCLAIMER ***
> This e-mail contains public information intended for any subscriber of
this
> mailing list and for anybody else who bothers to read it; it will be
copied,
> disclosed and distributed to the public. If you think you are not the
intended
> recipient, please commit suicide immediately.
> These terms apply also to any e-mails quoted in, referenced from, or
> answering this e-mail, and supersede any disclaimers in those e-mails.
> Additionally, disclaimers in those e-mails will incur legal processing
fees of
> $42 per line; you have agreed to this by reading this disclaimer.