message type 0x50 - Mailing list pgsql-general

From Alessandro GARDICH
Subject message type 0x50
Date
Msg-id 1063207106.1258.31.camel@motoko.loc
Whole thread Raw
Responses Re: message type 0x50
List pgsql-general
Hi to all

i received "message type 0x50 arrived from server while idle" ...

RedHat Linux 9, postgres 7.3.4

the program is quite simple, a loop do UPDATE on a random entry on a
table. Server is without autocommit.

with setittimer and SIGALRM i do an explicit COMMIT every 10 seconds,
update loop have a random delay from 0 to 500 msec using usleep().

I have problems using SIGALRM and libpq (libpqxx exactly), does libpq
use select or other signal ???

trying to substiture usleep with a null for loop i obtain the massage
"type 0x50..."

some suggestion ???

P.S. on the table there is a trigger that execute an NOTIFY every
update, but only one is received also if many updates happen between
commits ... why ???


--
Alessandro GARDICH <gremlin@gremlin.it>
gremlin.it

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.4 defaulting to ipv6 ?
Next
From: "Nigel J. Andrews"
Date:
Subject: Release date