8.3 and current_setting() of unset variables. Again

#1

Hi,

to access settings petersprc had this solution:

select setting from pg_catalog.pg_settings where name =
'modwork.transaction_id'

but this does not work. The table looks like this:

custom_variable_classes | modwork | | Customized Options

The variable 'transaction_id' is not accessible. How can you
query for the value of the custom variable?

PS: See old question some messages ago.

Thomas

#2

I still try to find a solution to check if a custom variable was set.

Unfortunately I think it is impossible to catch SQL exceptions in plpython:

try:
transaction_id=plpy.execute("SELECT
current_setting('modwork.transaction_id') AS id")[0]['id']
except:
assert False

'assert False' does not get executed.
I get this:

WARNING: plpython: in function get_or_create_transaction_id:
DETAIL: plpy.SPIError: Unknown error in PLy_spi_execute_query
ERROR: unrecognized configuration parameter "modwork.transaction_id"

Can someone help?

Thomas Guettler schrieb:

Quote:

Hi,

to access settings petersprc had this solution:

select setting from pg_catalog.pg_settings where name =
'modwork.transaction_id'

but this does not work. The table looks like this:

custom_variable_classes | modwork | | Customized Options

The variable 'transaction_id' is not accessible. How can you
query for the value of the custom variable?

PS: See old question some messages ago.

Thomas

#3

I still try to find a solution to check if a custom variable was set.

Unfortunately I think it is impossible to catch SQL exceptions in plpython:

try:
transaction_id=plpy.execute("SELECT
current_setting('modwork.transaction_id') AS id")[0]['id']
except:
assert False

'assert False' does not get executed.
I get this:

WARNING: plpython: in function get_or_create_transaction_id:
DETAIL: plpy.SPIError: Unknown error in PLy_spi_execute_query
ERROR: unrecognized configuration parameter "modwork.transaction_id"

Can someone help?

Thomas Guettler schrieb:

Quote:

Hi,

to access settings petersprc had this solution:

select setting from pg_catalog.pg_settings where name =
'modwork.transaction_id'

but this does not work. The table looks like this:

custom_variable_classes | modwork | | Customized Options

The variable 'transaction_id' is not accessible. How can you
query for the value of the custom variable?

PS: See old question some messages ago.

Thomas

#4

I still try to find a solution to check if a custom variable was set.

Unfortunately I think it is impossible to catch SQL exceptions in plpython:

try:
transaction_id=plpy.execute("SELECT
current_setting('modwork.transaction_id') AS id")[0]['id']
except:
assert False

'assert False' does not get executed.
I get this:

WARNING: plpython: in function get_or_create_transaction_id:
DETAIL: plpy.SPIError: Unknown error in PLy_spi_execute_query
ERROR: unrecognized configuration parameter "modwork.transaction_id"

Can someone help?

Thomas Guettler schrieb:

Quote:

Hi,

to access settings petersprc had this solution:

select setting from pg_catalog.pg_settings where name =
'modwork.transaction_id'

but this does not work. The table looks like this:

custom_variable_classes | modwork | | Customized Options

The variable 'transaction_id' is not accessible. How can you
query for the value of the custom variable?

PS: See old question some messages ago.

Thomas

#5

I still try to find a solution to check if a custom variable was set.

Unfortunately I think it is impossible to catch SQL exceptions in plpython:

try:
transaction_id=plpy.execute("SELECT
current_setting('modwork.transaction_id') AS id")[0]['id']
except:
assert False

'assert False' does not get executed.
I get this:

WARNING: plpython: in function get_or_create_transaction_id:
DETAIL: plpy.SPIError: Unknown error in PLy_spi_execute_query
ERROR: unrecognized configuration parameter "modwork.transaction_id"

Can someone help?

Thomas Guettler schrieb:

Quote:

Hi,

to access settings petersprc had this solution:

select setting from pg_catalog.pg_settings where name =
'modwork.transaction_id'

but this does not work. The table looks like this:

custom_variable_classes | modwork | | Customized Options

The variable 'transaction_id' is not accessible. How can you
query for the value of the custom variable?

PS: See old question some messages ago.

Thomas

#6

I still try to find a solution to check if a custom variable was set.

Unfortunately I think it is impossible to catch SQL exceptions in plpython:

try:
transaction_id=plpy.execute("SELECT
current_setting('modwork.transaction_id') AS id")[0]['id']
except:
assert False

'assert False' does not get executed.
I get this:

WARNING: plpython: in function get_or_create_transaction_id:
DETAIL: plpy.SPIError: Unknown error in PLy_spi_execute_query
ERROR: unrecognized configuration parameter "modwork.transaction_id"

Can someone help?

Thomas Guettler schrieb:

Quote:

Hi,

to access settings petersprc had this solution:

select setting from pg_catalog.pg_settings where name =
'modwork.transaction_id'

but this does not work. The table looks like this:

custom_variable_classes | modwork | | Customized Options

The variable 'transaction_id' is not accessible. How can you
query for the value of the custom variable?

PS: See old question some messages ago.

Thomas

#7

I still try to find a solution to check if a custom variable was set.

Unfortunately I think it is impossible to catch SQL exceptions in plpython:

try:
transaction_id=plpy.execute("SELECT
current_setting('modwork.transaction_id') AS id")[0]['id']
except:
assert False

'assert False' does not get executed.
I get this:

WARNING: plpython: in function get_or_create_transaction_id:
DETAIL: plpy.SPIError: Unknown error in PLy_spi_execute_query
ERROR: unrecognized configuration parameter "modwork.transaction_id"

Can someone help?

Thomas Guettler schrieb:

Quote:

Hi,

to access settings petersprc had this solution:

select setting from pg_catalog.pg_settings where name =
'modwork.transaction_id'

but this does not work. The table looks like this:

custom_variable_classes | modwork | | Customized Options

The variable 'transaction_id' is not accessible. How can you
query for the value of the custom variable?

PS: See old question some messages ago.

Thomas

#8

I still try to find a solution to check if a custom variable was set.

Unfortunately I think it is impossible to catch SQL exceptions in plpython:

try:
transaction_id=plpy.execute("SELECT
current_setting('modwork.transaction_id') AS id")[0]['id']
except:
assert False

'assert False' does not get executed.
I get this:

WARNING: plpython: in function get_or_create_transaction_id:
DETAIL: plpy.SPIError: Unknown error in PLy_spi_execute_query
ERROR: unrecognized configuration parameter "modwork.transaction_id"

Can someone help?

Thomas Guettler schrieb:

Quote:

Hi,

to access settings petersprc had this solution:

select setting from pg_catalog.pg_settings where name =
'modwork.transaction_id'

but this does not work. The table looks like this:

custom_variable_classes | modwork | | Customized Options

The variable 'transaction_id' is not accessible. How can you
query for the value of the custom variable?

PS: See old question some messages ago.

Thomas

#9

I still try to find a solution to check if a custom variable was set.

Unfortunately I think it is impossible to catch SQL exceptions in plpython:

try:
transaction_id=plpy.execute("SELECT
current_setting('modwork.transaction_id') AS id")[0]['id']
except:
assert False

'assert False' does not get executed.
I get this:

WARNING: plpython: in function get_or_create_transaction_id:
DETAIL: plpy.SPIError: Unknown error in PLy_spi_execute_query
ERROR: unrecognized configuration parameter "modwork.transaction_id"

Can someone help?

Thomas Guettler schrieb:

Quote:

Hi,

to access settings petersprc had this solution:

select setting from pg_catalog.pg_settings where name =
'modwork.transaction_id'

but this does not work. The table looks like this:

custom_variable_classes | modwork | | Customized Options

The variable 'transaction_id' is not accessible. How can you
query for the value of the custom variable?

PS: See old question some messages ago.

Thomas

#10

Thomas Guettler <hv (AT) tbz-pariv (DOT) de> wrote:

Quote:

to access settings petersprc had this solution:

select setting from pg_catalog.pg_settings where name =
'modwork.transaction_id'

but this does not work. The table looks like this:

custom_variable_classes | modwork | | Customized Options

The variable 'transaction_id' is not accessible. How can you
query for the value of the custom variable?

PS: See old question some messages ago.

I can confirm that the variable does not show up in pg_catalog.pg_settings,
but I had ne problem setting and retrieving it with SET and SHOW:

test=> SET modwork.transaction_id = 'sample';
SET

test=> SHOW modwork.transaction_id;
modwork.transaction_id
------------------------
sample
(1 row)

Does that help?

Yours,
Laurenz Albe