Postgres Pro
Downloads
Home   >   mailing lists

Re: [Patch proposal] libpq portal support - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: [Patch proposal] libpq portal support
Date
Msg-id CAMsr+YF9FDkZxh8ggVViz1QT-HysNLUenYMhezgS0eVTaux5XQ@mail.gmail.com
Whole thread Raw
In response to [Patch proposal] libpq portal support  (Sergei Fedorov <sergei.a.fedorov@gmail.com>)
Responses Re: [Patch proposal] libpq portal support
List pgsql-hackers
Tree view
On Thu, 17 Oct 2019 at 03:12, Sergei Fedorov <sergei.a.fedorov@gmail.com> wrote:
Hello everybody,

Our company was in desperate need of portals in async interface of libpq, so we patched it.

We would be happy to upstream the changes.

The description of changes:

Two functions in libpq-fe.h:
PQsendPortalBindParams for sending a command to bind a portal to a previously prepared statement;
PQsendPortalExecute for executing a previously bound portal with a given number of rows.

A patch to pqParseInput3 in fe-protocol3.c to handle the `portal suspended` message tag.

The patch is ready for review, but it lacks documentation, tests and usage examples.

There are no functions for sending bind without params and no functions for sync interface, but they can easily be added to the feature.

If you are happy to put it under The PostgreSQL License, then sending it as an attachment here is the first step.

If possible, please rebase it on top of git master.

Some explanation for why you have this need and what problems this solves for you would be helpful as well.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 2ndQuadrant - PostgreSQL Solutions for the Enterprise

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Proposal: Make use of C99 designated initialisers fornulls/values arrays
Next
From: "Jehan-Guillaume (ioguix) de Rorthais"
Date:
Subject: Re: Non working timeout detection in logical worker