Re: 7.0.2 dies when connection dropped mid-transaction

Alfred Perlstein <bright(at)wintelcom(dot)net> writes:
> I have a program that does a:
> DECLARE getsitescursor CURSOR FOR select...
> I ^C'd it and it didn't properly shut down the channel to
> postgresql and I got this crash:
> ...
> These sources are the current CVS sources with the exception of
> some removed files by Marc.

I tried this on my copy of 7.0.3:

test7=# begin; declare c cursor for select * from foo;
BEGIN
SELECT
test7=# fetch 1 from c;
f1
----
1
(1 row)

[kill -9 on the psql process from another window]

test7=# Killed

The postmaster log shows

pq_recvbuf: unexpected EOF on client connection

and no sign of a crash. So there's more to this than just killing
a client that has a cursor. Can you provide a more complete example?

regards, tom lane