agora inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: kaido vaikla <kaido.vaikla@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: event_trigger, 'DROP SCHEMA'
Date: Fri, 26 Jul 2024 13:44:01 -0400
Message-ID: <1747475.1722015841@sss.pgh.pa.us> (raw)
In-Reply-To: <CA+427g8LVfbbv5K36SxE8kK-_dqn4XhJTiKSx6XkLZ6givSo8Q@mail.gmail.com>
References: <CA+427g8LVfbbv5K36SxE8kK-_dqn4XhJTiKSx6XkLZ6givSo8Q@mail.gmail.com>

kaido vaikla <kaido.vaikla@gmail.com> writes:
> FOR r IN SELECT * FROM pg_event_trigger_dropped_objects()
> LOOP
> execute format ('drop role IF EXISTS r_%I', r.object_name);
> END LOOP;

> kvpg2=# drop schema test;
> ERROR:  null values cannot be formatted as an SQL identifier
> CONTEXT:  PL/pgSQL function trigger_after_drop_schema() line 7 at EXECUTE

> Question, what i do wrong?

Assume that every dropped object has a name, looks like.
You would probably do well to check object_type before
trying to drop the role.

			regards, tom lane

view thread (3+ messages)  latest in thread

Message-ID: <1747475.1722015841@sss.pgh.pa.us>
Permalink:  ../1747475.1722015841@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1747475.1722015841@sss.pgh.pa.us

reply

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-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, kaido.vaikla@gmail.com
  Subject: Re: event_trigger, 'DROP SCHEMA'
  In-Reply-To: <1747475.1722015841@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox