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
