Re: PL/SQL & unset custom variable

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gordon Ross <gr306(at)ucs(dot)cam(dot)ac(dot)uk>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PL/SQL & unset custom variable
Date: 2009-09-02 18:16:14
Message-ID: 14470.1251915374@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gordon Ross <gr306(at)ucs(dot)cam(dot)ac(dot)uk> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-09-02 18:26:01 Re: [Q] optmizing postgres for 'single client' / many small queries
Previous Message Tom Lane 2009-09-02 18:08:37 Re: Subselect problem