| From: | gomer94(at)yandex(dot)ru |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Cc: | gomer94(at)yandex(dot)ru |
| Subject: | BUG #14815: event trigger in extension |
| Date: | 2017-09-13 07:55:59 |
| Message-ID: | 20170913075559.25630.41587@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14815
Logged by: Galiev Mansur
Email address: gomer94(at)yandex(dot)ru
PostgreSQL version: 9.6.5
Operating system: Ubuntu 16.04.3 LTS x64
Description:
I want to create extension with sql like:
CREATE OR REPLACE FUNCTION keep_any_ddl_command() RETURNS event_trigger
LANGUAGE plpgsql
AS $$
BEGIN
SELECT classid, objid, objsubid FROM
pg_event_trigger_ddl_commands();
-- some insert code;
END;
$$;
CREATE TABLE ddl_events();
CREATE EVENT TRIGGER keep_all_ddl ON ddl_command_end
EXECUTE PROCEDURE keep_any_ddl_command();
but when i'm use CREATE EXTENSION i have:
ERROR: pg_event_trigger_ddl_commands() can only be called in an event
trigger function
CONTEXT: SQL statement "SELECT classid, objid, objsubid FROM
pg_event_trigger_ddl_commands()"
PL/pgSQL function keep_any_ddl_command() line 3 at SQL statement
if create this objects without extension, all ok
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 德哥 | 2017-09-13 08:11:49 | Re: BUG #14812: URI options cann't set with equal char. |
| Previous Message | pfcovello | 2017-09-13 07:48:11 | BUG #14814: Documentation errors for OpenBSD |