Jaime Casanova <ja...@2ndquadrant.com> writes:
> On Fri, Aug 6, 2010 at 12:50 PM, Robert Haas <robertmh...@gmail.com> wrote:
>> Just "DROP TABLE pg_temp_2.foo" or whatever and away you go.
> wow! that's true... and certainly a bug...
No, it's not a bug. You'll find only superusers can do it.
> we shouldn't allow any session to drop other session's temp tables, or
> is there a reason for this misbehavior?
It is intentional, though I'd be willing to give it up if we had more
bulletproof crash-cleanup of temp tables --- which is one of the things
this patch is supposed to result in.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
