Re: [RFC] Add an until-0 loop in psql
От
Daniel Verite
Тема
Re: [RFC] Add an until-0 loop in psql
Дата
Msg-id
29c2996c-ad55-42a7-bafe-79dc9d26add9@manitou-mail.org
Ответ на
Re: [RFC] Add an until-0 loop in psql (Corey Huinker)
Список
Дерево обсуждения
[RFC] Add an until-0 loop in psql Pierre Ducroquet <pierre.ducroquet@people-doc.com>
Re: [RFC] Add an until-0 loop in psql Corey Huinker <corey.huinker@gmail.com>
Re: [RFC] Add an until-0 loop in psql "Daniel Verite" <daniel@manitou-mail.org>
Re: [RFC] Add an until-0 loop in psql Pierre Ducroquet <pierre.ducroquet@people-doc.com>
Re: [RFC] Add an until-0 loop in psql Corey Huinker <corey.huinker@gmail.com>
Re: [RFC] Add an until-0 loop in psql Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [RFC] Add an until-0 loop in psql Pavel Stehule <pavel.stehule@gmail.com>
Re: [RFC] Add an until-0 loop in psql Corey Huinker <corey.huinker@gmail.com>
Re: [RFC] Add an until-0 loop in psql Pavel Stehule <pavel.stehule@gmail.com>
Re: [RFC] Add an until-0 loop in psql Corey Huinker <corey.huinker@gmail.com>
Re: [RFC] Add an until-0 loop in psql Pavel Stehule <pavel.stehule@gmail.com>
Re: [RFC] Add an until-0 loop in psql Pavel Stehule <pavel.stehule@gmail.com>
Corey Huinker wrote: > As of v11, DO blocks can do transactions. I think this will meet your needs. They do support COMMIT and ROLLBACK in the current development tree, but not VACUUM as in Pierre's example. postgres=# \echo :SERVER_VERSION_NAME 11devel postgres=# do ' begin vacuum; end '; ERROR: VACUUM cannot be executed from a function CONTEXT: SQL statement "vacuum" PL/pgSQL function inline_code_block line 1 at SQL statement Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite
В списке pgsql-hackers по дате отправления