On Thu, 1 Mar 2007, mikie wrote:
Yes, that is nice way to work with databases, but I am on PHP4 and I am not using the PDO.
MDB2 has a similar sintaxis.
But getting back to my problem - perhaps there is something I misunderstood: is it the client application responsibility to check if the transaction failed or succeeded and issue COMMIT or ROLLBACK accordingly (how do I close the transaction block in that case)? Or is it the database server that is suppose to check if transaction succeded and perform the query, or ROLLBACK if anything went wrong?
PG will rollback all transactions that have an error in some part, as it can't commit the transaction as a whole.
-- 21:50:04 up 2 days, 9:07, 0 users, load average: 0.92, 0.37, 0.18 --------------------------------------------------------- Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador ---------------------------------------------------------