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

Поиск
Список
Период
Сортировка
От Bernice Southey
Тема Re: Add notification on BEGIN ATOMIC SQL functions using temp relations
Дата
Msg-id CAEDh4nxXYxbPQQiHBUY6pg3cFxbUKQFdERQ_i6EqDhUm=-Ksyg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Add notification on BEGIN ATOMIC SQL functions using temp relations  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote:
>if a temp table is used to
> define an old-style function's argument or result type, eg
>         create function get_mytable() returns setof mytable as ...
> This is problematic because the function will go away when mytable
> does, no matter how its body is expressed.
I briefly did try using my temp table as the result type and was
delighted I could, but my client library wasn't. I had no idea I'd
accidentally made my functions weirdly temporary, so your notice would
have been very useful.

Thanks, Bernice



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