Re: ALTER OBJECT any_name SET SCHEMA name

Heikki Linnakangas <heikki.linnakangas@enterprisedb.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_sqlLOOP  …END LOOP;

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support