Visibility of temporary database objects - Mailing list pgsql-general

From Allan Kamau
Subject Visibility of temporary database objects
Date
Msg-id ab1ea6540912140035l60eb08b8hf582754608364d1f@mail.gmail.com
Whole thread Raw
Responses Re: Visibility of temporary database objects  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
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 threaded application which could use the same connection in
more than one thread(is this possible/or even safe). I would like to
avoid the possibility that the created temporary objects get dropped
outside the current thread that created them.


Allan.

pgsql-general by date:

Previous
From: Alexander Pyhalov
Date:
Subject: Get bytes sent to client
Next
From: "Philippe Lang"
Date:
Subject: Dependency tracking tool