| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>, Josh Berkus <josh(at)agliodbs(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Zhaomo Yang <zhy001(at)cs(dot)ucsd(dot)edu>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Robert Haas <robertmhaas(at)gmail(dot)com> |
| Subject: | Re: Implementation of global temporary tables? |
| Date: | 2015-07-20 09:55:06 |
| Message-ID: | CAFj8pRCOuUw8zN8eOXiDOhcDy_dmb6ixb06hRP-dFbZbE+p1mg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
2015-07-20 11:07 GMT+02:00 Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>:
> Pavel Stehule wrote:
> > 2015-07-20 5:33 GMT+02:00 Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>:
> >
> > > Would it be difficult to add the ability for one user to share the
> > > contents with a list of named other users (roles)?
> >
> > Probably it is possible, but not for temporary data - short data are in
> > process memory, so it are not accessible from other sessions.
> >
> > This sharing tables needs:
> >
> > 1. some infrastructure to hold data about sharing - who can share with
> what
> > 2. who will clean data? temporary data are cleaned on end of transaction
> or
> > end of session
> > 3. data should be saved in shared memory instead process memory
> >
> > So it is possible, but partially different
>
> To me this gets in the "crazy ideas" list. Please add it to the TODO
> page in the wiki, so that we're sure we never implement it.
>
yes, it is pretty crazy - Have no plan to implement it :)
Pavel
> --
> Álvaro Herrera http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2015-07-20 10:14:31 | Re: [HACKERS] object_classes array is broken, again |
| Previous Message | Andres Freund | 2015-07-20 09:46:47 | Re: Re: [COMMITTERS] pgsql: Retain comments on indexes and constraints at ALTER TABLE ... TY |