Re: Can't Figure Out Where Rows Are Going - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: Can't Figure Out Where Rows Are Going
Date
Msg-id 5.2.1.1.1.20060507174419.02ad8008@localhost
Whole thread Raw
In response to Re: Can't Figure Out Where Rows Are Going  (HH <lists@lastonepicked.com>)
Responses Re: Can't Figure Out Where Rows Are Going
List pgsql-general
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.



pgsql-general by date:

Previous
From: Peter Kovacs
Date:
Subject: Re: Can't Figure Out Where Rows Are Going
Next
From: Volkan YAZICI
Date:
Subject: Re: intarray internals