Re: Add notification on BEGIN ATOMIC SQL functions using temp relations

From: Vik Fearing <vik(at)postgresfriends(dot)org>
To: Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Add notification on BEGIN ATOMIC SQL functions using temp relations
Date: 2025-09-21 14:43:51
Message-ID: 4b10fae9-1566-40aa-a63a-1917e05eb31e@postgresfriends.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 21/09/2025 13:49, Jim Jones wrote:
> WARNING: function defined with BEGIN ATOMIC depends on temporary
> relation "tmp"
> DETAIL: the function will be dropped automatically at session end.
> CREATE FUNCTION

In addition to what others have said, this DETAIL line needs to be
contextual.  The temporary table could have been declared as ON COMMIT
DROP in which case the function will only last until transaction end.

--

Vik Fearing

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Steve Lau 2025-09-21 14:48:33 [PATCH] Correct RangeTblEntry.join_using_alias comment to reflect field order
Previous Message David G. Johnston 2025-09-21 13:52:45 Add notification on BEGIN ATOMIC SQL functions using temp relations