Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
The application "foo" uses this plpythonu source code to read the custom variable foo.transaction_id.
I guess this is way too complicated.
How to shorten/simplify below lines?
txid_list = list(plpy.execute(
'''SELECT current_setting FROM current_setting('foo.transaction_id')'''))
txid_str = txid_list [0]['current_setting']
txid = int(txid_str)
Based on the documentation, you won't be able to simplify this. plpy offers a quite limited set of DB access functions, so you have to do everything using those - basically the way you do it already.
select current_setting('foo.transaction_id')would just be the same, but I doubt there is a big difference in performance. Not sure if it's possible in Python do do something liketxid := current_setting('foo.transaction_id')(as in PL/pgSQL)