Re: Flexible permissions for REFRESH MATERIALIZED VIEW

Поиск
Список
Период
Сортировка
От Dmitry Dolgov
Тема Re: Flexible permissions for REFRESH MATERIALIZED VIEW
Дата
Msg-id CA+q6zcVNyASx4T9w_GpRHWzUBJNUKmWceX3OYN388raRSqX-sg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Flexible permissions for REFRESH MATERIALIZED VIEW  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Flexible permissions for REFRESH MATERIALIZED VIEW  (Dmitry Dolgov <9erthalion6@gmail.com>)
Список pgsql-hackers
> On Mon, 21 May 2018 at 15:46, Robert Haas <robertmhaas@gmail.com> wrote:
>
> On Sat, May 19, 2018 at 12:59 PM, Greg Stark <stark@mit.edu> wrote:
> > On 19 May 2018 at 01:13, Stephen Frost <sfrost@snowman.net> wrote:
> >> I'm not entirely sure about the varlena suggestion, seems like that
> >> would change a great deal more code and be slower, though perhaps not
> >> enough to matter; it's not like our aclitem arrays are exactly optimized
> >> for speed today.
> >
> > I don't actually understand the reason y'all are talking about
> > varlena.
>
> Because aclitem's typlen value in pg_type is currently "12".

This patch went through the last two commit fests without any noticeable
activity. As far as I can see, judging from the discussion, there isn't a
single opinion everyone would agree with, except that simply introducing a new
permission is probably not enough and we need to address how to do this
in an extendable way.

> On Sun, 18 Mar 2018 at 22:05, Isaac Morland <isaac.morland@gmail.com> wrote:
>
> Right now I'm really looking for whether anybody observes any problems with
> the basic idea. If it's considered to be at least in principle a good idea
> then I'll go and make a more complete patch.

There were at least two options suggested about how to address the questions
from the discussion (widening AclMode and introducing another type similar to
aclitem, but more flexible, to store an "extended" permissions). Maybe the
constructive approach here would be to try them out and propose a draft
implementation for one of them?


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: zheap: a new storage format for PostgreSQL
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pread() and pwrite()