Re: pg11rc1 DROP INDEX: NOTICE: drop_trigger

2018-10-16 Thread Sergei Kornilov 
Hi

Maybe you have some event trigger? Please check pg_event_trigger system view: 
https://www.postgresql.org/docs/11/static/catalog-pg-event-trigger.html

regards, Sergei

Re: pg11rc1 DROP INDEX: NOTICE: drop_trigger

2018-10-15 Thread Justin Pryzby 
On Mon, Oct 15, 2018 at 03:44:52PM -0400, Tom Lane wrote:
> Justin Pryzby  writes:
> > ts=#  CREATE INDEX ON t(i) ;
> > CREATE INDEX
> > ts=#  DROP INDEX t_i_idx ;
> > NOTICE:  0: drop_trigger
> > LOCATION:  exec_stmt_raise, pl_exec.c:3748
> > DROP INDEX
> 
> Maybe you've got an event trigger hanging around in that DB?

You're right; I was following along this bug report:
https://www.postgresql.org/message-id/flat/20180924103001.GK2471%40telsasoft.com#b066078913137fe462c24c0884d186e1

Thanks, all's well.

Justin

Re: pg11rc1 DROP INDEX: NOTICE: drop_trigger

2018-10-15 Thread Tom Lane 
Justin Pryzby  writes:
> ts=#  CREATE INDEX ON t(i) ;
> CREATE INDEX
> ts=#  DROP INDEX t_i_idx ;
> NOTICE:  0: drop_trigger
> LOCATION:  exec_stmt_raise, pl_exec.c:3748
> DROP INDEX

Maybe you've got an event trigger hanging around in that DB?

regards, tom lane