Re: Access a temporary table of another session - is it possible ? - Mailing list pgsql-general

From Tom Lane
Subject Re: Access a temporary table of another session - is it possible ?
Date
Msg-id 19924.1138122182@sss.pgh.pa.us
Whole thread Raw
In response to Access a temporary table of another session - is it possible ?  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-general
Csaba Nagy <nagy@ecircle-ag.com> writes:
> As the subject says, I would like to access a temporary table of another
> session, while being the postgres superuser. Is this possible somehow ?

No.  It is not a matter of permissions, it is a matter of physically not
having access to the data: buffers for temp tables are private to
individual backends, not shared, for performance reasons.

            regards, tom lane

pgsql-general by date:

Previous
From: Yl Zhou
Date:
Subject: Re: user defined function
Next
From: Tom Lane
Date:
Subject: Re: user defined function