Re: temp tables ORACLE/PGSQL

Tony Caduto wrote:

> This is not entirely correct.   We use temp tables all the time in 
> PLpgsql functions and never have to use
> execute.  We have found that you have to use EXECUTE only in certain 
> circumstances.
>
>
> we use this in all our functions that use temp tables, and we use PG 
> Lightning Admin, which refreshes the
> connection each time you run a query which gets around a lot of issues 
> with temp tables.


If you refresh the connection each time you run a query,  maybe you 
don't need to use EXECUTE with temporary tables in stored procedures, 
but who does that in a production database application? Most people want 
to re-use connections for performance reasons.

Dennis