Re: Custom runtime variables - Mailing list pgsql-general

From Tom Lane
Subject Re: Custom runtime variables
Date
Msg-id 22245.1245984836@sss.pgh.pa.us
Whole thread Raw
In response to Custom runtime variables  (Scott Bailey <artacus@comcast.net>)
Responses Re: Custom runtime variables  (Scott Bailey <artacus@comcast.net>)
List pgsql-general
Scott Bailey <artacus@comcast.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

pgsql-general by date:

Previous
From: Scott Bailey
Date:
Subject: Custom runtime variables
Next
From: Gerhard Wiesinger
Date:
Subject: Re: Problems with postgres online backup - restore