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.
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 |
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 |