Re: problem with notify/listen

I assume this item is still open.  I put it in the 7.3 queue:
http://candle.pha.pa.us/cgi-bin/pgpatches2

---------------------------------------------------------------------------

Barry Lind wrote:
> I have just been looking into a bug report against the jdbc driver and I 
> found the following behavior that I can't explain.
> 
> If I run jdbc with setAutoCommit=true then notifications work as 
> expected, however if I run with setAutoCommit=false then notifications 
> are not being sent from the backend to the client.
> 
> With autoCommit=false the jdbc driver is sending the following SQL 
> commands to the server:
> 
> begin
> select 1
> commit;begin;
> select 1
> commit;begin;
> select 1
> ...
> 
> My test code is using the select statement as a means to poll for the 
> notifications.  The only thing that is unusual about this is that the 
> "commit;begin;" command string is sent to the server as a single query 
> to be processed.
> 
> With autoCommit=true the SQL commands are simply:
> 
> select 1
> select 1
> select 1
> ...
> 
> In this mode the notifications work correctly.
> 
> Is there something I am doing wrong, or is this expected behavior for 
> the server?
> 
> thanks,
> --Barry
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026