Horton

Re: Error with DEFAULT VALUE in temp table

Антуан Виолин <violin.antuan@gmail.com>

View thread View on postgr.es
From: Антуан Виолин <violin.antuan@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2025-06-30T07:46:27Z
Lists: pgsql-hackers

Attachments

> Hi everyone,
> I found one bug, when you delete temporary table with DEFAULT VALUE. The
> row about this VALUE in the pg_event_trigger_dropped_objects() contains
> “False” in the column “is_temporary”. But if you look at column “name_obj”,
> you see “for pg_temp.table_name”. So PostgreSQL know, that it is temporary.
>
> Cheers
>
> Antoine Violin\
>
Hi everyone,
I made patch for this problem, I changed event_trigger, for
definitions of temporality
DEFAULT VALUE

Cheers

Antoine Violin

Commits

  1. Fix oversights in pg_event_trigger_dropped_objects() fixes.

  2. Report the correct is_temporary flag for column defaults.