Are the relevant COMMITs appearing in the log?
If the commits fail for whatever reason does/can the application (and
postgresql) log that?
If the commits are successful then you shouldn't have to need to look for
roll-backs.
It might be a good idea for teh webapp to log unsuccessful commits. And
maybe even log important commits that are successful.
Regards,
Link.
At 05:30 PM 5/6/2006 -0700, HH wrote:
Thanks for taking the time to reply.
If that was occurring, would the log show it? I don't see any sign of a
roll-back occurring in the log and when I run the queries in psql, they seem
to complete properly.