Re: pg11rc1 DROP INDEX: NOTICE: drop_trigger

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg11rc1 DROP INDEX: NOTICE: drop_trigger
Date: 2018-10-15 19:55:19
Message-ID: 20181015195519.GP10792@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Oct 15, 2018 at 03:44:52PM -0400, Tom Lane wrote:
> Justin Pryzby <pryzby(at)telsasoft(dot)com> writes:
> > ts=# CREATE INDEX ON t(i) ;
> > CREATE INDEX
> > ts=# DROP INDEX t_i_idx ;
> > NOTICE: 00000: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2018-10-15 20:07:54 Large writable variables
Previous Message Tom Lane 2018-10-15 19:52:42 Re: Use of pager, help, localization: