pg_variables
pg_variables copied to clipboard
postgrespro
Session wide variables for PostgreSQL
It's possible to insert into variable record from table even if amount of fields in the row are different. But there is an error on select variable after insert from...
Now it throws a weird error: ``` + valgrind --tool=memcheck --leak-check=no --time-stamp=yes --track-origins=yes --trace-children=yes --gen-suppressions=all --suppressions=/pg/testdir/postgresql/src/tools/valgrind.supp --suppressions=/pg/testdir/valgrind.supp --log-file=/tmp/valgrind-%p.log pg_ctl start -l /tmp/postgres.log -w 438valgrind: /pg/testdir/pg_bin/bin/pg_ctl: Operation not permitted ``` For...
Hello pg_variables is session-only visibility. I am wondering if you can make it globally visible. In this way, the pg_variables can become similar to Redis.
PostgreSQL 14.6 (Ubuntu 14.6-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit pg_variables 1.2.5 I discovered erroneous behaviour with chains of updates to the record variable followed by an...
Hello, The [documentation](https://postgrespro.ru/docs/enterprise/15/ch16s01?lang=en) says that autonomous transactions cannot be used with pg_variables. I wrote a small test case using pgv_get, pgv_set and autonomous transactions and it worked without errors. Can...
Hello, I use the extension in order to set up the current app security context for audit triggers. There is a connection pooler, working in the transaction pooling mode, meaning...
