On Thu, Dec 15, 2016 at 12:24 PM, Andrew Borodin <boro...@octonica.com> wrote: > 2016-12-15 0:30 GMT+05:00 Peter Eisentraut <peter.eisentr...@2ndquadrant.com>: >>>>> TryBeginSession()? >>>> >>>> What exactly would that do? >>> Return status (success\failure) and session object, if a function succeeded. >>> >>> If there is max_connections exceeded, then (false,null). >>> >>> I'm not sure whether this idiom is common for Python. >> >> You can catch PostgreSQL exceptions in PL/Python, so this can be handled >> in user code. >> >> Some better connection management or pooling can probably be built on >> top of the primitives later, I'd say. > > Agree, doing this in Python is the better option. > > And one more thing... Can we have BackgroundSessionExecute() splitted > into two parts: start query and wait for results? > It would allow pg_background to reuse bgsession's code. > +1
Regards, Amul -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
