I read the docs but I'm still not sure. If I create a temp table with ON
COMMIT DROP then is that table private to the transaction? In other
words, if the temp table is created in plpgsql stored procedure foo
and foo is executed from different transactions in parallel then each
transaction
On Wed, Jul 11, 2007 at 10:28:25PM +0530, Joshua N Pritikin wrote:
and foo is executed from different transactions in parallel then each
transaction will see its own private temp table, right?
They will see their own private temp tables _no matter what_.
There's no shared temp table support
On 07/11/07 12:06, Andrew Sullivan wrote:
On Wed, Jul 11, 2007 at 10:28:25PM +0530, Joshua N Pritikin wrote:
and foo is executed from different transactions in parallel then each
transaction will see its own private temp table, right?
They will see their own private temp tables _no matter
On Wed, Jul 11, 2007 at 02:36:54PM -0500, Ron Johnson wrote:
Will GLOBAL TEMP tables be added any time soon?
I think there's a recent thread/bunfight about this topic on
-hackers. You may want to draw your own conclusions on the basis of
what you see there -- I'm not willing to speculate :)