From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Bogus NULL object_name from pg_event_trigger_dropped_objects()
Date: Mon, 15 Nov 2021 12:48:10 -0300
Message-ID: <202111151548.zbalpm4zpnjy@alvherre.pgsql> (raw)
In-Reply-To: <2123408.1636990185@sss.pgh.pa.us>
On 2021-Nov-15, Tom Lane wrote:
> I chanced to experiment with the event trigger function shown in
> 9.29.2. Processing Objects Dropped by a DDL Command [1].
> I got
>
> et=# create table t1(f1 text primary key);
> CREATE TABLE
> et=# drop table t1;
> NOTICE: DROP TABLE dropped object: table public.t1 public.t1
> NOTICE: DROP TABLE dropped object: type public.t1 public.t1
> NOTICE: DROP TABLE dropped object: type public._t1 public.t1[]
> NOTICE: DROP TABLE dropped object: toast table pg_toast.pg_toast_38092 pg_toast.pg_toast_38092
> NOTICE: DROP TABLE dropped object: index pg_toast.pg_toast_38092_index pg_toast.pg_toast_38092_index
> NOTICE: DROP TABLE dropped object: table constraint public.<NULL> t1_pkey on public.t1
> NOTICE: DROP TABLE dropped object: index public.t1_pkey public.t1_pkey
> DROP TABLE
> et=#
>
> Note the faulty output for the pkey constraint. I've not looked
> for the cause.
Egad.
Looking ...
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: alvherre@alvh.no-ip.org, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
Subject: Re: Bogus NULL object_name from pg_event_trigger_dropped_objects()
In-Reply-To: <202111151548.zbalpm4zpnjy@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox