Re: transactions from PHP - double COMMIT required?

mikie wrote:
> 2007/3/2, Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>:
>> mikie wrote:
>> > 2007/3/1, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>:
>> >> Yeah, do the above recommendation to see if all of your statements are
>> >> making
>> >> thier way into pg
>> >
>> > OK, I have checked the logs. I can see both COMMIT statements in the
>> > log - the first commit from my transaction and then the other that I
>> > send to workaround the problem.
>>
>> There must be some other problem. Do you have trasaction ID on the logs?
>> See if both commits go in the same transaction.
>
> Could you please advise me how to check the transaction ID in the log?

Edit postgresql.conf:

log_line_prefix = '<%t %x>'

And restart postmaster.

>> Any errors during the transaction?
>
> As I wrote in my first post, I make this error intentionally to check
> if transaction works (if something fails, then the entire transaction
> should be rolled back). I intentionally give wrong data in the "date"
> field for example.
> Perhaps I should ask again: is it my responsibility to check if the
> transaction failed and issue a ROLLBACK command, or will the PG server
> do it automatically?

One question: Why dont you but each query in a diferent pg_exec() command?

--
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
---------------------------------------------------------