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

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Re: Add notification on BEGIN ATOMIC SQL functions using temp relations
Дата
Msg-id 4b10fae9-1566-40aa-a63a-1917e05eb31e@postgresfriends.org
обсуждение исходный текст
Ответ на Add notification on BEGIN ATOMIC SQL functions using temp relations  (Jim Jones <jim.jones@uni-muenster.de>)
Список 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




В списке pgsql-hackers по дате отправления: