Re: ALTER OBJECT any_name SET SCHEMA name

On 31.10.2010 20:19, Dimitri Fontaine wrote:
> Heikki Linnakangas<heikki(dot)linnakangas(at)enterprisedb(dot)com> writes:
>>> In particular, embedded and/or dynamic calls in PLs will get hairy if
>>> not turing complete and outright impossible to solve.
>>
>> Sorry, I don't follow. Got an example?
>
> Well, who's to say the following hypothetical plpgsql example should be
> forgiven only in an exception's script?
>
> v_sql := 'SELECT * FROM ' || p_fun || '()';
> FOR rec in EXECUTE v_sql
> LOOP
> …
> END LOOP;

If I understand that correctly, the idea is that p_fun holds the name of
a function that's in the same schema as the extension? You would write
that as

v_sql := 'SELECT * FROM @extschema(at)(dot)' || p_fun || '()';
FOR rec in EXECUTE v_sql
LOOP
…
END LOOP;

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com