Re: Custom runtime variables

2009/6/26 Scott Bailey <artacus(at)comcast(dot)net>:
>
>> Scott Bailey <artacus(at)comcast(dot)net> writes:
>>>
>>> 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.
>>
>> No, it doesn't.  It should still work in set/show though.
>>
>>> Also, can the variable be stored in a specific data type or am I stuck
>>> with text?
>>
>> There's no data type associated with it.  This is all an artifact of the
>> fact that this isn't a genuine designed-in feature, but a kluge that
>> someone shoehorned in.  You should have to declare the variable in some
>> fashion...
>>
>>                        regards, tom lane
>
> Thanks Tom. So how about accessing it from from plpgsql or sql?

look on http://www.postgresql.org/docs/8.3/interactive/functions-admin.html#FUNCTIONS-ADMIN-SET-TABLE

regards
Pavel Stehule

>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>