Re: [GENERAL] insert select fails inside of function

2012-06-22 Thread Tom Lane
Benedict Holland 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 > crea

Re: [GENERAL] insert select fails inside of function

2012-06-22 Thread Benedict Holland
Hi Tom, 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, ...) a

Re: [GENERAL] insert select fails inside of function

2012-06-22 Thread Tom Lane
Benedict Holland writes: > I am scratching my head over this one. I have a basic function which > populates a table inside of it (declared outside of the function but that > shouldn't matter) and it requires something like > insert into table1 (col1, ...) > select * from foo > and I get the err