Subject RE: [firebird-support] Re: how to use a transaction in SP
Author Dmitry Yemanov
Alex,

> Dmitry, AFAIR explicit savepoint usage was allowed on client side
> only, not in SP. Am I wrong?

You're right, savepoints are not available in PSQL.

> To be honest, during 8 years with IB/FB I
> never wanted transactions control in SP. MSSQL connections are just
> tubes to send statements and get data, they don't really control
> processing, in FB we can control absolutly all from client. And if we
> need to handle exceptions on server side, we have WHEN handler and
> implicit savepoints usage controlled by begin-end blocks.

Absolutely correct.


Dmitry