Re: psql: rollback only last query on error

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: psql: rollback only last query on error
Дата
Msg-id 20040921133452.GB2780@dcc.uchile.cl
обсуждение исходный текст
Ответ на psql: rollback only last query on error  ("Michael Paesold" <mpaesold@gmx.at>)
Список pgsql-patches
On Tue, Sep 21, 2004 at 02:30:17PM +0200, Michael Paesold wrote:
> I am sorry for kind of reposting this, but I have not got any response to my
> patch sent for comment to hackers (Subject: Rollback on error):
> http://archives.postgresql.org/pgsql-hackers/2004-09/msg00576.php
>
> I just want to find out, if I should try to solve the issues with this patch
> (and add regression tests, docs, etc.) now or leave it till after release of
> version 8.0.

One potential problem I see with the patch is that it opens lots of
savepoints but does not release any.  In this mode, given autocommit off
(and even without that), there's potential for lots and lots of
savepoints.  Not sure how to fix that given that you shouldn't release
user-specified savepoints ...

Also, you need to do something with \i.  I think the global variable
will be a less intrusive approach, at least while we are in beta.  When
8.1 development starts, you can submit a patch to clean up.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Cada quien es cada cual y baja las escaleras como quiere" (JMSerrat)


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

Предыдущее
От: "Michael Paesold"
Дата:
Сообщение: psql: rollback only last query on error
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: psql \set case sensitive for boolean (OFF/off)