Re: [HACKERS] Inconsistent syntax in GRANT - Mailing list pgsql-patches

From Marko Kreen
Subject Re: [HACKERS] Inconsistent syntax in GRANT
Date
Msg-id e51f66da0601060911i314b0fabxda60fbd949f4f9a2@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Inconsistent syntax in GRANT  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [HACKERS] Inconsistent syntax in GRANT
Re: [HACKERS] Inconsistent syntax in GRANT
List pgsql-patches
On 1/6/06, Bruce Momjian <pgman@candle.pha.pa.us> wrote:
> Bruno Wolff III wrote:
> > It might be nice to split nextval and currval access as well. nextval access
> > corresponds to INSERT and currval access to SELECT.
>
> Uh, that is already in the code.  nextval()/setval() is UPDATE, and
> currval() is SELECT.

This seems weird.  Shouldn't nextval/currval go together and setval
separately?

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.

--
marko

[removing Tom from CC as he bounces gmail]

pgsql-patches by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: display and expression of the home directory in Win32
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Inconsistent syntax in GRANT