Re: Custom runtime variables
От
Pavel Stehule
Тема
Re: Custom runtime variables
Дата
Msg-id
162867790906260149u114e2c88q92d66765c2865e09@mail.gmail.com
Ответ на
Re: Custom runtime variables (Scott Bailey)
Список
Дерево обсуждения
Custom runtime variables Scott Bailey <artacus@comcast.net>
Re: Custom runtime variables Tom Lane <tgl@sss.pgh.pa.us>
Re: Custom runtime variables Scott Bailey <artacus@comcast.net>
Re: Custom runtime variables Pavel Stehule <pavel.stehule@gmail.com>
Re: Custom runtime variables Andreas Kretschmer <akretschmer@spamfence.net>
Re: Custom runtime variables artacus@comcast.net
2009/6/26 Scott Bailey : > >> Scott Bailey 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
В списке pgsql-general по дате отправления
