public inbox for [email protected]
help / color / mirror / Atom feedODBC fails to recognize event trigger removal
2+ messages / 1 participants
[nested] [flat]
* ODBC fails to recognize event trigger removal
@ 2025-11-23 12:44 Igor Korot <[email protected]>
2025-11-23 18:17 ` Fwd: ODBC fails to recognize event trigger removal Igor Korot <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Igor Korot @ 2025-11-23 12:44 UTC (permalink / raw)
To: pgsql-generallists.postgresql.org <[email protected]>
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?
Thank you.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Fwd: ODBC fails to recognize event trigger removal
2025-11-23 12:44 ODBC fails to recognize event trigger removal Igor Korot <[email protected]>
@ 2025-11-23 18:17 ` Igor Korot <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Igor Korot @ 2025-11-23 18:17 UTC (permalink / raw)
To: PostgreSQL ODBC list <[email protected]>
Originally sent to PostgreSQL general ML.
Thank you.
---------- Forwarded message ---------
From: Igor Korot <[email protected]>
Date: Sun, Nov 23, 2025 at 4:44 AM
Subject: ODBC fails to recognize event trigger removal
To: pgsql-generallists.postgresql.org <[email protected]>
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?
Thank you.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-11-23 18:17 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-11-23 12:44 ODBC fails to recognize event trigger removal Igor Korot <[email protected]>
2025-11-23 18:17 ` Igor Korot <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox