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
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
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
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
ts=#
ts=# \d t
Table "public.t"
Column | Type | Collation | Nullable | Default
