Re: synchronized snapshots
От
Joachim Wieland
Тема
Re: synchronized snapshots
Дата
Msg-id
CACw0+13N-XuT-zi7WkRTK1LKZjsNt_sowMu+iXdwP9K+96=HVw@mail.gmail.com
Ответ на
Re: synchronized snapshots (Jim Nasby)
Список
Дерево обсуждения
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
Дата: