Re: Problem trying to implement version 3.0 of the PostgreSQL protocol

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carlos Guzman Alvarez <carlosga(at)telefonica(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Problem trying to implement version 3.0 of the PostgreSQL protocol
Date: 2003-06-04 21:16:56
Message-ID: 27324.1054761416@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Carlos Guzman Alvarez <carlosga(at)telefonica(dot)net> writes:
> You are right thanks very much, but now i have another problem, i don't
> get response from the postgresql server, hummm this is what i'm sending
> for test:

Your Parse message looks fine, but the server will not actually send its
ParseComplete response until you send a Sync or Flush message. The idea
is that Parse is usually going to be part of a series of operations, and
you don't want a separate network packet coming back for each operation
in the series. When you do want to see the results of an operation
before you issue the next one, you can issue either Flush (just forces
out the pending messages) or Sync (which does all the stuff that was
formerly done at the end of a Query message).

Error messages do get flushed out immediately, which is why you were
able to see the response in the other case.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-06-04 21:33:46 Aggregates containing outer references don't work per spec
Previous Message Carlos Guzman Alvarez 2003-06-04 20:31:33 Re: Problem trying to implement version 3.0 of the PostgreSQL protocol