Re: synchronized snapshots

Поиск
Список
Период
Сортировка
Искать
От
Joachim Wieland
Тема
Re: synchronized snapshots
Дата
Msg-id
CACw0+13N-XuT-zi7WkRTK1LKZjsNt_sowMu+iXdwP9K+96=HVw@mail.gmail.com
Ответ на
Список
Дерево обсуждения
synchronized snapshots Joachim Wieland <joe@mcknight.de>
Re: synchronized snapshots Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: synchronized snapshots Joachim Wieland <joe@mcknight.de>
Re: synchronized snapshots Jim Nasby <jim@nasby.net>
Re: synchronized snapshots Joachim Wieland <joe@mcknight.de>
Re: synchronized snapshots Jim Nasby <jim@nasby.net>
Re: synchronized snapshots Jeff Davis <pgsql@j-davis.com>
Re: synchronized snapshots Jim Nasby <jim@nasby.net>
Re: synchronized snapshots Tom Lane <tgl@sss.pgh.pa.us>
Re: synchronized snapshots Jeff Davis <pgsql@j-davis.com>
Re: synchronized snapshots Peter Eisentraut <peter_e@gmx.net>
Re: synchronized snapshots Bruce Momjian <bruce@momjian.us>
Re: synchronized snapshots Peter Eisentraut <peter_e@gmx.net>
Re: synchronized snapshots Robert Haas <robertmhaas@gmail.com>
Re: synchronized snapshots Tom Lane <tgl@sss.pgh.pa.us>
Re: synchronized snapshots Robert Haas <robertmhaas@gmail.com>
Re: synchronized snapshots Jeff Davis <pgsql@j-davis.com>
Re: synchronized snapshots Robert Haas <robertmhaas@gmail.com>
Re: synchronized snapshots Robert Haas <robertmhaas@gmail.com>
Re: synchronized snapshots Alvaro Herrera <alvherre@commandprompt.com>
Re: synchronized snapshots Robert Haas <robertmhaas@gmail.com>
Re: synchronized snapshots Simon Riggs <simon@2ndQuadrant.com>
Re: synchronized snapshots PostgreSQL - Hans-Jürgen Schönig<postgres@cybertec.at>
Re: synchronized snapshots Andres Freund <andres@anarazel.de>
Re: synchronized snapshots Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: synchronized snapshots Robert Haas <robertmhaas@gmail.com>
Re: synchronized snapshots "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: synchronized snapshots Florian Weimer <fweimer@bfk.de>
Re: synchronized snapshots Joachim Wieland <joe@mcknight.de>
Re: synchronized snapshots Joachim Wieland <joe@mcknight.de>
Re: synchronized snapshots Marko Tiikkaja <marko.tiikkaja@2ndquadrant.com>
Re: synchronized snapshots Joachim Wieland <joe@mcknight.de>
Re: synchronized snapshots Tom Lane <tgl@sss.pgh.pa.us>
Re: synchronized snapshots Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: synchronized snapshots Florian Pflug <fgp@phlo.org>
Re: synchronized snapshots Tom Lane <tgl@sss.pgh.pa.us>
Re: synchronized snapshots Robert Haas <robertmhaas@gmail.com>
Re: synchronized snapshots "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: synchronized snapshots Florian Pflug <fgp@phlo.org>
Re: synchronized snapshots "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: synchronized snapshots Tom Lane <tgl@sss.pgh.pa.us>
Re: synchronized snapshots Thom Brown <thom@linux.com>
Re: synchronized snapshots Tom Lane <tgl@sss.pgh.pa.us>
Re: synchronized snapshots Thom Brown <thom@linux.com>
Re: synchronized snapshots Marko Tiikkaja <marko.tiikkaja@2ndquadrant.com>
Re: synchronized snapshots Simon Riggs <simon@2ndQuadrant.com>
Re: synchronized snapshots Tom Lane <tgl@sss.pgh.pa.us>
Re: synchronized snapshots Simon Riggs <simon@2ndQuadrant.com>
Re: synchronized snapshots Joachim Wieland <joe@mcknight.de>
On Mon, Aug 15, 2011 at 6:09 PM, Jim Nasby  wrote:
> I suspect that all the other cases of BEGIN failing would be syntax errors, so
> you would immediately know in testing that something was wrong. A missing file
> is definitely not a syntax error, so we can't really depend on user testing to ensure
> this is handled correctly. IMO, that makes it critical that that error puts us in an
> aborted transaction.

Why can we not just require the user to verify if his BEGIN query
failed or succeeded?
Is that really too much to ask for?

Also see what Robert wrote about proxies in between that keep track of
the transaction
state. Consider they see a BEGIN query that fails. How would they know
if the session
is now in an aborted transaction or not in a transaction at all?


Joachim

В списке pgsql-hackers по дате отправления
От: Peter Geoghegan
Дата:
От: Jim Nasby
Дата:
FAQ