Michael Fuhr <mike@xxxxxxxx> writes:
> On Tue, Apr 19, 2005 at 05:39:42PM -0700, Dennis Sacks wrote:
>> I am Seeing twelve of these messages every five to ten seconds in the
>> Postgresql serverlog when my java application is running:
>>
>> 2005-04-19 16:43:03 LOG: 00000: duration: 0.246 ms
>> LOCATION: exec_simple_query, postgres.c:960
>> 2005-04-19 16:43:03 LOG: 00000: statement: rollback; begin;
>> LOCATION: pg_parse_query, postgres.c:464
> Looks like the application is aborting its transaction (rollback)
> and starting a new one (begin). If you're not doing this explicitly
> then the API is probably doing it under the hood.
I think older versions of the JDBC driver will do that behind your back
... try the latest driver, and if you still see it then inquire on
pgsql-jdbc.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
