Skip site navigation (1) Skip section navigation (2)

Re: insert/update/delete statements returning a query response

From: Barry Lind <barry(at)xythos(dot)com>
To: Stuart Robinson <stuart(at)zapata(dot)org>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: insert/update/delete statements returning a query response
Date: 2001-11-27 02:16:47
Message-ID: 3C02F78F.500@xythos.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
Stuart,

FE/BE = Frontend/Backend protocol.  It is the over the wire protocol 
Postgres uses to talk to clients (jdbc, odbc, libpq, etc.).

It is documented in the Developers Guide, there is a chapter titled 
"Frontend/Backend Protocol".

thanks,
--Barry

Stuart Robinson wrote:

> What is the FE/BE protocol? (I did a Google search and found references to
> it, but no definitions or explanations.) Thanks. (And apologies if this is
> a stupid RTFM sort of question.)
> 
> -Stuart
> 
> On Mon, 26 Nov 2001, Barry Lind wrote:
> 
> 
>>Is this behavior intended in the backend?  The problem is that when you
>>create a rule on an object that calls a stored function and invoke that
>>rule on an insert/update/delete statement your insert/update/delete
>>statement will now return a query result to the front end over the FE/BE
>>protocol.  (I am not sure this is the exact senerio, but something
>>similar).  This means that the user now needs to perform a
>>executeQuery() call when using these insert/update/delete statements in
>>JDBC because the JDBC driver isn't able to accept a query response when
>>issuing a insert/update/delete call.
>>
>>thanks,
>>--Barry
>>
> 



In response to

pgsql-hackers by date

Next:From: Barry LindDate: 2001-11-27 02:20:03
Subject: Re: [HACKERS] insert/update/delete statements returning a query response
Previous:From: Bruce MomjianDate: 2001-11-27 02:01:31
Subject: Re: 7.2 stuff

pgsql-jdbc by date

Next:From: Barry LindDate: 2001-11-27 02:20:03
Subject: Re: [HACKERS] insert/update/delete statements returning a query response
Previous:From: Barry LindDate: 2001-11-27 02:13:12
Subject: Re: [Fwd: Re: [Fwd: Re: Problems with truncated BLOB]]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group