Re: [HACKERS] libpq and SPI - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] libpq and SPI
Date
Msg-id 199905092010.QAA25661@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] libpq and SPI  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Is this fixed?


> > What is the problem? I'll research a SPI patch.
> 
> Check the hackers thread (last month I think) titled "libpq and SPI";
> the problem occurs when one submits a utility statement rather than
> a plannable query via SPI.  Apparently what is happening is that the
> backend emits a 'T' message before it invokes the called statement
> and then emits a 'D' message afterwards --- so if the called statement
> causes a 'C' message to come out, libpq gets unhappy.  This seems
> to be clearly a violation of the FE/BE protocol to me, so I don't think
> it's libpq's fault.
> 
> Reasonable fixes might be to postpone the sending of 'T' till after
> the invoked statement is executed, or to modify the traffic cop so
> that a utility statement invoked from SPI doesn't send 'C'.
> 
> I know a little bit about the parts of the backend that communicate with
> the frontend, but nothing about SPI, so I'm not well prepared to solve
> the problem by myself.
> 
>             regards, tom lane
> 
> 


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Comments on columns?
Next
From: Taral
Date:
Subject: Re: [HACKERS] inet data type regression test fails