Hmmm. If I do:
select * from pg_settings where name='custom_variable_classes'; I see my entry "phone", but I can't see how I can tell if I've set "phone.id" GTG ________________________________________ From: Tom Lane [[email protected]] Sent: 02 September 2009 19:16 To: Gordon Ross Cc: [email protected] Subject: Re: [GENERAL] PL/SQL & unset custom variable Gordon Ross <[email protected]> writes: > Sorry, no joy :-( > grails=> SELECT current_setting('phone.id'); > ERROR: unrecognized configuration parameter "phone.id" > grails=> SELECT coalesce(current_setting('phone.id'),'SYSTEM'); > ERROR: unrecognized configuration parameter "phone.id" You could use a SELECT from pg_settings to probe for the value of the parameter without getting an error. regards, tom lane -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
