Postgresql/pg_pconnect/temp tables

[Anon]

Hi,

I am creating and using temp tables in stored procedures. It work fine with pg_connect()/pg_close(), but when I initialize my connexions with pg_pconnect() it seems like temporaries tables are not destoy at all until the connexion lives...

How can I solve that?

Thanks

[[deleted]]

Another good reason not to use temp tables :-)

Temp tables are created 'pre connection' and are only removed when the connection is closed.

When you use pconnect, the connections are not closed.
What's worse, the connections are shared for your scripts, so if one script makes a temp table, the next script can read it (even if it did not create it).

The easiest solution would be to give your temp tables unique names, like a sessionid.
And you'll have to destroy the temp tables manually.

[Anon]

hi vincent,

I can not create on the fly a table with a uid or a random generate name because I need to take a value from it in the stored procedure, and it is impossible to do get a value from a "execute" instruction to initialize a variable... so I need to know exactly the table name to get a result from it.

do you know another solution?

thanks,
bye