Re: Postgre Protocol

Hi Tom, thanks for the quick reply. I've looked at the break points and you are right there are 7 more bytes with data send with AuthenticationOk message, so I think thats what I need to look at :) (Im sure this is just a confirmation that everything is ok).

May I ask, sequence of bytes after the AuthenticationOk messages is: 0080003; Is this sequence represent BackendKeyData or values for Authentication*** status codes, or Im completely worng and it is realy nothing but confirmation for a frontend how the database applied options passed with start-up packet?

Thanks!
Greg.

--- On Mon, 28/6/10, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: [NOVICE] Postgre Protocol
To: "Greg" <grigorey(at)yahoo(dot)co(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Date: Monday, 28 June, 2010, 19:08

Greg <grigorey(at)yahoo(dot)co(dot)uk> writes:
> So question is after I recive AuthenticationOk, do I need to wait for
> ReadyForQuery message from the database

Yes.  You should have gotten it --- the backend is designed to coalesce
those messages into a single network packet, so as to avoid extra
network traffic.  I wonder whether your code is failing to notice
additional logical messages arriving in the same bufferload.

            regards, tom lane