Request a Demo
Home   >   mailing lists

Re: Add notification on BEGIN ATOMIC SQL functions using temp relations - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: Add notification on BEGIN ATOMIC SQL functions using temp relations
Date
Msg-id 4b10fae9-1566-40aa-a63a-1917e05eb31e@postgresfriends.org
Whole thread Raw
In response to Add notification on BEGIN ATOMIC SQL functions using temp relations  (Jim Jones <jim.jones@uni-muenster.de>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Add notification on BEGIN ATOMIC SQL functions using temp relations
Next
From: Steve Lau
Date:
Subject: [PATCH] Correct RangeTblEntry.join_using_alias comment to reflect field order