Re: cursors and function question

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: cursors and function question
Дата
Msg-id CAKFQuwZW_mUz4pYb0hUiAywcQcb2+4Rf9bow0zKikxzWGCu84Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: cursors and function question  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: cursors and function question  (armand pirvu <armand.pirvu@gmail.com>)
Список pgsql-general
On Tue, Feb 13, 2018 at 3:31 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
2) By global table do you mean a temporary table? If so not sure that is going to work as I am pretty sure it will disappear after the function is run.

​Temporary tables can survive until either session or transaction end - neither of which occurs automatically when exiting a function.


"Temporary tables are automatically dropped at the end of a session, or optionally at the end of the current transaction (see ON COMMIT below)"

David J.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: cursors and function question
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: PostgreSQL Download