Re: [GENERAL] Visibility of temporary database objects

2009-12-14 Thread Craig Ringer
On 14/12/2009 4:35 PM, Allan Kamau wrote: > and I am calling this function in from a threaded application which could use the same connection in more than one thread(is this possible/or even safe). No! Admittedly it depends on the client interface/driver, but at least for direct psql, PgODBC

[GENERAL] Visibility of temporary database objects

2009-12-14 Thread Allan Kamau
Hi all, I have a simple question: Are the temporary database objects created within a pgplsql function visible/available outside the function (or implicit transaction) in any way. I am dropping and creating temporary database objects within a function and I am calling this function in from a thread