[HACKERS] More about "CREATE TABLE" from inside a function/trigger...

[Dominic J. Eidson]

As per my previous post on this matter:
http://www.postgresql.org/mhonarc/pgsql-general/2000-08/msg00326.html

... somebody responded to me in private (IIRC - don't remember the name,
and can't find it in the archives), saying that this had been fixed in 7.1
- I assumed this meant it already was in CVS, and as it turns out, that's
not the case. Having gotten latest (CVS as of a few hours ago) working and
loaded the database(s), I still get the exact same errors as before... Any
clues as to if/when this will be fixed? (If it won't, or is of so little
priority that it's far in the future - a simple "Won't happen" will work.)

Thanks in advance,
--
Dominic J. Eidson
"Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/

[Tom Lane]

I believe you could do CREATE TABLE from inside a pltcl or plperl
function today. plpgsql won't work because it tries to cache query
plans for repeated execution --- which essentially means that you
can only substitute parameters for data values, not for table names
or field names or other structural aspects of a query. But the other
two just treat queries as dynamically-generated strings, so you can
do anything you want in those languages. (At a performance price,
of course: no caching. There ain't no such thing as a free lunch.)

regards, tom lane