Re: Backend not sending ReadyForQuery packet?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: chris(at)gammu(dot)ath(dot)cx
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Backend not sending ReadyForQuery packet?
Date: 2002-01-22 15:07:02
Message-ID: 14809.1011712022@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Christian von Kietzell <chris(at)gammu(dot)ath(dot)cx> writes:
> I have sent the startup packet to the postmaster who responded with
> "R0". Afterwards I get a BackendKeyData packet from the backend.
> According to the docs I'm not supposed to send anything but to wait
> for the backend to send a ReadyForQuery packet which never comes.
> I've analysed the TCP traffic psql generates. Oddly enough, even psql
> doesn't wait for this packet but sends "Qselect getdatabaseencoding()"
> instantly.

Are you sure that the ReadyForQuery message (a single 'Z') isn't
arriving in the same packet as the BackendKeyData message? The
backend doesn't do unnecessary flushes, so I'd fully expect those
to arrive in the same TCP packet.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-01-22 15:23:49 Re: PostgreSQL Licence: GNU/GPL
Previous Message Vince Vielhaber 2002-01-22 15:04:32 Re: PostgreSQL Licence: GNU/GPL