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 [tgl@xxxxxxxxxxxxx]
Sent: 02 September 2009 19:16
To: Gordon Ross
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: PL/SQL & unset custom variable
Gordon Ross <gr306@xxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
