| From: | Igor Korot <ikorot01(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | ODBC fails to recognize event trigger removal |
| Date: | 2025-11-23 12:44:58 |
| Message-ID: | CA+FnnTx0_jSe-aynLXMjrZhdBsSjw_mpCRP_cWH1oACo9=o2DA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-odbc |
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(at)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(at)WaylandGnome ~/unixODBC-2.3.12 $
[/code]
Server version 16.2
Driver version 11.1
Anybody aware of this?
Thank you.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2025-11-23 16:41:44 | Re: ODBC fails to recognize event trigger removal |
| Previous Message | Igor Korot | 2025-11-23 04:29:40 | Re: Way to retrieve UserName/Password |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2025-11-23 16:41:44 | Re: ODBC fails to recognize event trigger removal |
| Previous Message | Dave Cramer | 2025-11-17 20:41:53 | Re: Guidance on avoiding session pinning with psqlODBC and RDS Proxy |