Re: global temporary tables

Alvaro Herrera <alvherre@commandprompt.com>

From: Alvaro Herrera <alvherre@commandprompt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>, Greg Sabino Mullane <greg@turnstep.com>, pgsql-hackers@postgresql.org
Date: 2010-04-26T20:18:47Z
Lists: pgsql-hackers
Tom Lane escribió:
> [ forgot to respond to this part ]
> 
> Robert Haas <robertmhaas@gmail.com> writes:
> > ...  I don't see the problem with DROP.
> > Under the proposed design, it's approximately equivalent to dropping a
> > table that someone else has truncated.  You just wait for the
> > necessary lock and then do it.
> 
> And do *what*?  You can remove the catalog entries, but how are you
> going to make the physical storage of other backends' versions go away?
> (To say nothing of making them flush their local buffers for it.)

Maybe we could add a sinval message to that effect.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support