Error bundling script file with extension when event trigger commands are used

From: sanyam jain <sanyamjain22(at)live(dot)in>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Error bundling script file with extension when event trigger commands are used
Date: 2017-12-06 06:36:36
Message-ID: PN1PR01MB0653DADA62CE303C8EF92106C0320@PN1PR01MB0653.INDPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I am trying to bundle a script file with my extension. Script has event triggers and trigger function does a select query on pg_event_trigger_ddl_commands .

While executing "create extension" following error is thrown :

ERROR: pg_event_trigger_ddl_commands() can only be called in an event trigger function
CONTEXT: SQL statement "SELECT * FROM pg_event_trigger_ddl_commands() WHERE object_type ='table'

Found that there is already a bug posted related to this
https://www.postgresql.org/message-id/flat/20170913075559(dot)25630(dot)41587%40wrigleys(dot)postgresql(dot)org#20170913075559(dot)25630(dot)41587(at)wrigleys(dot)postgresql(dot)org

I couldn't understand much from the above thread but like to solve this problem.

Thanks,
Sanyam Jain

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2017-12-06 06:43:07 Re: [HACKERS] parallel.c oblivion of worker-startup failures
Previous Message amul sul 2017-12-06 06:15:17 Re: pgsql: Support Parallel Append plan nodes.