Postgres Pro
Downloads
Home   >   mailing lists

Re: how does a temp table work? - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: how does a temp table work?
Date
Msg-id 20070711170622.GZ1241@phlogiston.dyndns.org
Whole thread Raw
In response to how does a temp table work?  (Joshua N Pritikin <jpritikin@pobox.com>)
Responses Re: how does a temp table work?  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Tree view 
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 in Postgres.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
Everything that happens in the world happens at some place.
        --Jane Jacobs

pgsql-general by date:

Previous
From: Joshua N Pritikin
Date:
Subject: how does a temp table work?
Next
From: Bohdan.Linda
Date:
Subject: auditing question