Re: insert select fails inside of function

Benedict Holland <benedict.m.holland@gmail.com> writes:
> Thanks for the response. The PG version is 9.0. I can't really give you the
> text of the function unfortunately. I know though that there isn't any
> aliasing issues occurring. After commenting out all but one line, I have it
> down to, not a insert select but a

> create temp table t1(id, ...) as
> select (a few columns with names that don't match)
> where etc.

Hm.  A CREATE TABLE AS SELECT case works for me in 9.0.8.  Perhaps you
could sanitize what you've got into a small self-contained test case?

            regards, tom lane