public inbox for pgsql-odbc@postgresql.org
help / color / mirror / Atom feedFrom: Adrian Klaver <adrian.klaver@aklaver.com>
To: Igor Korot <ikorot01@gmail.com>
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: ODBC fails to recognize event trigger removal
Date: Sun, 23 Nov 2025 08:41:44 -0800
Message-ID: <e84231cb-4964-463c-a24c-061443de9bc9@aklaver.com> (raw)
In-Reply-To: <CA+FnnTx0_jSe-aynLXMjrZhdBsSjw_mpCRP_cWH1oACo9=o2DA@mail.gmail.com>
References: <CA+FnnTx0_jSe-aynLXMjrZhdBsSjw_mpCRP_cWH1oACo9=o2DA@mail.gmail.com>
On 11/23/25 04:44, Igor Korot wrote:
> Hi, ALL,
>
> [code]
> postgres=# CREATE OR REPLACE FUNCTION __watch_schema_changes() RETURNS
> event_trigger LANGUAGE plpgsql AS $$ BEGIN NOTIFY tg_tag; END; $$;
> CREATE FUNCTION
> postgres=# CREATE EVENT TRIGGER schema_change_notify ON
> ddl_command_end WHEN TAG IN('CREATE TABLE', 'ALTER TABLE', 'DROP
> TABLE', 'CREATE INDEX', 'DROP INDEX') EXECUTE PROCEDURE
> __watch_schema_changes();
> CREATE EVENT TRIGGER
> postgres=# DROP EVENT TRIGGER schema_change_notify CASCADE;
> DROP EVENT TRIGGER
> postgres=# \q
> igor@WaylandGnome ~/unixODBC-2.3.12 $ isql postgres postgres wasqra123
> +---------------------------------------+
> | Connected! |
> | |
> | sql-statement |
> | help [tablename] |
> | echo [string] |
> | quit |
> | |
> +---------------------------------------+
> SQL> CREATE OR REPLACE FUNCTION __watch_schema_changes() RETURNS
> event_trigger LANGUAGE plpgsql AS $$ BEGIN NOTIFY tg_tag; END; $$;
> SQLRowCount returns -1
> SQL> CREATE EVENT TRIGGER schema_change_notify ON ddl_command_end WHEN
> TAG IN('CREATE TABLE', 'ALTER TABLE', 'DROP TABLE', 'CREATE INDEX',
> 'DROP INDEX') EXECUTE PROCEDURE __watch_schema_changes();
> [ISQL]ERROR: Could not SQLExecute
> SQL> quit
> igor@WaylandGnome ~/unixODBC-2.3.12 $
> [/code]
>
> Server version 16.2
> Driver version 11.1
>
> Anybody aware of this?
1) There is a Postgres list dedicated to the ODBC driver:
https://www.postgresql.org/list/pgsql-odbc/
You should probably ask these sort of questions there.
2) I have to believe the below is the issue:
Server version 16.2
Driver version 11.1
Given that the most recent current driver is REL-17_00_0006 and from here:
https://github.com/postgresql-interfaces/psqlodbc/tree/REL-11_01_0000
The 11.1 driver was released 6 years ago which predates the release of
Postgres 16 by ~4.5 years.
>
> Thank you.
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-odbc@postgresql.org
Cc: adrian.klaver@aklaver.com, ikorot01@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: ODBC fails to recognize event trigger removal
In-Reply-To: <e84231cb-4964-463c-a24c-061443de9bc9@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox