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
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 |
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 |