[GENERAL] how does a temp table work?

2007-07-11 Thread Joshua N Pritikin
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

Re: [GENERAL] how does a temp table work?

2007-07-11 Thread Andrew Sullivan
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

Re: [GENERAL] how does a temp table work?

2007-07-11 Thread Ron Johnson
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

Re: [GENERAL] how does a temp table work?

2007-07-11 Thread Andrew Sullivan
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 :)