"Shoaib Mir" <[EMAIL PROTECTED]> writes:
> Try using it with 'execute' as that might help...
In current releases you need EXECUTE, else the thing will try to cache a
query plan using the OID of the first instance of the temp table, and
that won't work for subsequent instances.
> OR:
> CREATE TEMP
Try using it with 'execute' as that might help...
OR:
CREATE TEMP TABLE tblname WITH (OIDS) ON COMMIT DROP AS select * from
someothertbl;
that means the temporary table will be dropped at the end of the current
transaction block.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 7/16/07, C
Hi All,
Running into a small issue with a PL/PGSQL function under PostgreSQL
8.0.11...
epassembly=# select version();
version
-
PostgreSQL 8.0.11 on x86_64-unk
