Frontend/backend protocol improvements proposal (request).

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Frontend/backend protocol improvements proposal (request).
Date: 2013-06-20 15:08:35
Message-ID: CAAfz9KMdqKhhPi9KZN1XM1sDzbuep_bJQCNCLi4yS2NQGd78vQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hackers,

While developing a C++ client library for Postgres I felt lack of extra
information in command tags in the CommandComplete (B) message
for the following commands:
PREPARE;
DEALLOCATE;
DECLARE;
CLOSE;
LISTEN;
UNLISTEN;
SET;
RESET.
Namely, for example, users of my library can prepare statements by using
protocol directly or via PREPARE command. Since the protocol does not
supports prepared statement deallocation, I wrote a wrapper over DEALLOCATE
command. The library knows about all prepared statements and
invalidates them automatically when user performs deallocate() wrapper.
But users can go with DEALLOCATE command directly and in these cases
I need to query the database to get the list of currently prepared
statements
whenever CommandComplete message with DEALLOCATE command tag
is consumed. Moreover, I need to do it *synchronously* and this breaks
asynchronous API.
I propose to include name of the object in the CommandComplete (B)
message for the above commands.

--
// Dmitriy.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message salah jubeh 2013-06-20 15:58:35 Replication with Drop: could not open relation with OID
Previous Message Tim Kane 2013-06-20 15:02:31 Re: Order by with column ordinal and collate - fails to parse

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2013-06-20 15:13:17 Re: MVCC catalog access
Previous Message Robert Haas 2013-06-20 15:04:26 Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements