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
Ответ на
Список
Дерево обсуждения
[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 по дате отправления
От: Andrey Borodin
Дата:
От: Pierre Ducroquet
Дата:
FAQ