RE: How to watch for schema changes

-----Original Message-----
From: Igor Korot [mailto:ikorot01(at)gmail(dot)com]
Sent: Tuesday, December 04, 2018 11:07 AM
To: Igor Neyman <ineyman(at)perceptron(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>; pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to watch for schema changes

Igor,

On Tue, Dec 4, 2018 at 8:20 AM Igor Neyman <ineyman(at)perceptron(dot)com> wrote:
>
>
> -----Original Message-----
> From: Igor Korot [mailto:ikorot01(at)gmail(dot)com]
> Sent: Monday, December 03, 2018 8:29 AM
> To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
> Subject: Re: How to watch for schema changes
>
> ...................
>
> And executing LISTEN will also work for ODBC connection, right?
>
> Thank you.
>
> _______________________________________________________________________________________________
>
> It's been years since we dealt with this problem, so the details are fuzzy.
>
> All applications in the package we develop connect to PG using ODBC, but one app that's using LISTEN is connecting to PG through native interface libpq.dll, ODBC didn't work for that purpose, at least at the time.

I will try it and report back.
Out of curiosity - when was the last time you tried?

Thank you.
_____________________________________________________________________________________________

PG release 8.4.