Re: Extending grant insert on tables to sequences

From: Abhijit Menon-Sen <ams(at)oryx(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Jaime Casanova <systemguards(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Extending grant insert on tables to sequences
Date: 2008-07-09 18:58:37
Message-ID: 20080709185837.GA27406@toroid.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

At 2008-07-08 09:32:44 -0400, alvherre(at)commandprompt(dot)com wrote:
>
> > > The idea of this patch is to avoid the need to make explicit
> > > grants on sequences owned by tables. [...]
>
> I had a look at this patch and it looks good. The only thing that's
> not clear to me is whether we have agreed we want this to be the
> default behavior?

For what it's worth, I quite like the idea.

(I looked at the patch, and it looks good to me too.)

> Wouldn't it be clearer to build a list with all the sequences owned by
> the tables in istmt.objects, and then call ExecGrantStmt_oids() a
> single time with the big list?

i.e., to hoist most of the istmt_seq initialisation out of the loop,
right? Yes, that makes sense.

-- ams

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ken Camann 2008-07-09 19:03:48 Re: Summary of some postgres portability issues
Previous Message Josh Berkus 2008-07-09 18:54:05 Re: [PATCHES] GIN improvements

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2008-07-09 19:11:25 Re: Extending grant insert on tables to sequences
Previous Message Josh Berkus 2008-07-09 18:54:05 Re: [PATCHES] GIN improvements