From: | Marko Kreen <markokr(at)gmail(dot)com> |
---|---|
To: | Bruno Wolff III <bruno(at)wolff(dot)to>, Marko Kreen <markokr(at)gmail(dot)com>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Josh Berkus <josh(at)agliodbs(dot)com>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] Inconsistent syntax in GRANT |
Date: | 2006-01-06 19:06:09 |
Message-ID: | e51f66da0601061106l314b6c25g57d68f43e394241b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On 1/6/06, Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
> On Fri, Jan 06, 2006 at 19:11:27 +0200,
> Marko Kreen <markokr(at)gmail(dot)com> wrote:
> > On 1/6/06, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
> >
> > Considering there's no currval() without nextval(), what point
> > is disallowing currval() when user is able to call nextval()?
> >
> > I rather want to allow nextval/currval and disable setval as it
> > allows regular user to DoS the database.
>
> What I was thinking with this, is that you might allow someone the ability
> to insert records into a table which would make use of nextval, but not
> allow them to run nextval directly. But after inserting a record allow them
> to use currval to see what value was assigned.
> People could still mess with things by doing INSERTs and aborting the
> transaction, so this may not be the best example for why you would want this.
This is similar to Tom's scenario. I'm not against keeping them separate.
But my question is rather - is there any scenario where setval() should
go with nextval()?
It seems that their pairing is an accident and should be fixed.
--
marko
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-01-06 20:31:46 | Re: [HACKERS] Inconsistent syntax in GRANT |
Previous Message | Marko Kreen | 2006-01-06 18:59:32 | Re: [HACKERS] Inconsistent syntax in GRANT |
From | Date | Subject | |
---|---|---|---|
Next Message | Joachim Wieland | 2006-01-06 19:27:39 | psql tab completion enhancements |
Previous Message | Marko Kreen | 2006-01-06 18:59:32 | Re: [HACKERS] Inconsistent syntax in GRANT |