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. Best regards, Andrey Borodin. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers