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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-jdbc by date

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