Re: killing process question

--okay, but the client has since terminated
--it's session (if i understand you correctly).

--is this just something that will just have to
--hang around until i shutdown the database / boot
--the machine?

-X

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, September 19, 2002 11:50 AM
To: shridhar_daithankar(at)persistent(dot)co(dot)in
Cc: 'pgsql-general(at)postgresql(dot)org'; pgsql-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] killing process question

"Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> writes:
> I guess a backend should terminate as if connection is closed. What say?

No.

It will terminate when it tries to read the next query from the client.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster