Re: Event Triggers and Dropping Objects

2019-12-16 Thread chikolette-postgre...@yahoo.com
Le lundi 16 décembre 2019 à 11:13:10 UTC+1, Luca Ferrari a écrit : On Mon, Oct 7, 2019 at 10:12 PM Bruce Momjian wrote: > Do the Postgres docs need improvement here? I don't know, but I would probably add a flag column in the firing matrix to indicate when the related function will return a n

Re: Event Triggers and Dropping Objects

2019-10-09 Thread Luca Ferrari
On Mon, Oct 7, 2019 at 10:12 PM Bruce Momjian wrote: > Do the Postgres docs need improvement here? I don't know, but I would probably add a flag column in the firing matrix to indicate when the related function will return a null tuple. Luca

Re: Event Triggers and Dropping Objects

2019-10-07 Thread Bruce Momjian
On Sat, Oct 5, 2019 at 10:50:14AM +0200, Luca Ferrari wrote: > On Fri, Oct 4, 2019 at 10:38 PM Miles Elam wrote: > > > > The event trigger firing matrix lists tags like DROP TABLE and DROP > > FUNCTION are listed below the ddl_command_end event, but when I created a > > basic audit table and ev

Re: Event Triggers and Dropping Objects

2019-10-05 Thread Miles Elam
Thanks, it does! On Sat, Oct 5, 2019 at 1:50 AM Luca Ferrari wrote: > On Fri, Oct 4, 2019 at 10:38 PM Miles Elam > wrote: > > > > The event trigger firing matrix lists tags like DROP TABLE and DROP > FUNCTION are listed below the ddl_command_end event, but when I created a > basic audit table

Re: Event Triggers and Dropping Objects

2019-10-05 Thread Luca Ferrari
On Fri, Oct 4, 2019 at 10:38 PM Miles Elam wrote: > > The event trigger firing matrix lists tags like DROP TABLE and DROP FUNCTION > are listed below the ddl_command_end event, but when I created a basic audit > table and event trigger, they don't seem to fire. I know sql_drop exists, but > aga

Event Triggers and Dropping Objects

2019-10-04 Thread Miles Elam
The event trigger firing matrix lists tags like DROP TABLE and DROP FUNCTION are listed below the ddl_command_end event, but when I created a basic audit table and event trigger, they don't seem to fire. I know sql_drop exists, but again the matrix lists DROP commands in the ddl_command_end event.