Postgres Pro
Downloads
Home   >   mailing lists

Error bundling script file with extension when event trigger commandsare used - Mailing list pgsql-hackers

From sanyam jain
Subject Error bundling script file with extension when event trigger commandsare used
Date
Msg-id PN1PR01MB0653DADA62CE303C8EF92106C0320@PN1PR01MB0653.INDPRD01.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: Error bundling script file with extension when event triggercommands are used  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Tree view

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 

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

Thanks,
Sanyam Jain

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: explain analyze output with parallel workers - question aboutmeaning of information for explain.depesz.com
Next
From: Amit Kapila
Date:
Subject: Re: [HACKERS] parallel.c oblivion of worker-startup failures