The following bug has been logged online:

Bug reference:      3423
Logged by:          vituko
Email address:      [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system:   debian sarge
Description:        cache on temporary tables in plpgsql
Details: 

"relation with OID ##### does not exist" errors when accessing temporary
tables in PL/PgSQL functions

related :
bug : 2005-12/msg00207.php : 
possible solution :
faq : 4.19
but :

I'm working on 7.4 and execute command cannot return any value (execute into
is not implemented). So I cannot see any alternative. Any suggestions?

I have a loop "for record in select...", for each record, I get a table name
and then I do an 'execute query', creating a temporary table and from this
temporary table I need a field value.

What can I do?

Thank you very much.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to