Custom runtime variables

From: Scott Bailey <artacus(at)comcast(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Custom runtime variables
Date: 2009-06-26 01:32:19
Message-ID: 4A442523.10208@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I want to be able to change the behavior of some functions based on
custom runtime variables.

I added the following lines to my postgresql.conf file:

custom_variable_classes = 'foo'
foo.name = '1s'

Now if I do "show foo.name" I get '1s'
But it does not show up in show all or in pg_settings.

I didn't find much in the way of documentation. How does one access the
value of foo.name from a plpgsql or sql function?

Also, can the variable be stored in a specific data type or am I stuck
with text?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-06-26 02:53:56 Re: Custom runtime variables
Previous Message Chris Spotts 2009-06-26 00:12:13 Re planned recovery from a certain transaction