Re: Error with DEFAULT VALUE in temp table

From: Антуан Виолин <violin(dot)antuan(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Error with DEFAULT VALUE in temp table
Date: 2025-06-30 07:46:27
Message-ID: CAFjUV9ygrdpkcykvMis0pPwsJdJ+jZVB98mEgDb=w2qBpyXbjQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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\
>
Hi everyone,
I made patch for this problem, I changed event_trigger, for
definitions of temporality
DEFAULT VALUE

Cheers

Antoine Violin

Attachment Content-Type Size
v1-changed-event_trigger-for-DEFAULT-VALUE.patch text/x-patch 4.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip Kumar 2025-06-30 07:51:24 Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages
Previous Message Антуан Виолин 2025-06-30 07:36:09 Re: Error with DEFAULT VALUE in temp table