Ühel kenal päeval, R, 2006-03-17 kell 11:27, kirjutas Peter Eisentraut: > Am Freitag, 17. März 2006 11:25 schrieb Hannu Krosing: > > > => commit; > > > ROLLBACK > > > ^^^^^^^^ > > > > Return status tells you what actually happened. > > If I send a COMMIT, I want a commit to happen or an error.
You already got several errors. Any suggestion how to get out of the ERROR state ? => begin; BEGIN => blah; ERROR: ... => commit; ERROR: ... => select 1; ERROR: current transaction is aborted, commands ignored until end of transaction block Or would you like a mode where you need explicitly send a ROLLBACK to get out ? > > > Even if this is justifiable, this behavior is not documented (in any > > > obvious place). > > > > What would you suggest as an obvious place ? > > The COMMIT reference page would be a start. Good point :) ------------ Hannu ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
