Horton

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: 2024-12-07T11:38:02Z
Lists: pgsql-hackers 
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

Commits

  1. Fix oversights in pg_event_trigger_dropped_objects() fixes.

  2. Report the correct is_temporary flag for column defaults.