Ühel kenal päeval, R, 2006-03-17 kell 14:10, kirjutas Peter Eisentraut: > Am Freitag, 17. März 2006 13:03 schrieb Hannu Krosing: > > > If I send a COMMIT, I want a commit to happen or an error. > > > > You already got several errors. > > Right, but a defensively programmed application, I want to get all the errors > all the time at every possible place. > > > Or would you like a mode where you need explicitly send a ROLLBACK to > > get out ? > > I faintly recall that this used to be the behavior.
in 7.4 it was worse ahf=# begin; BEGIN ahf=# select 1/0; ERROR: division by zero ahf=# commit; COMMIT it still did a rollback, but reported a COMMIT ----------- Hannu ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
