Jaime Casanova wrote:
> On 1/6/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> > Marko Kreen <[EMAIL PROTECTED]> writes:
> > > 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.
> >
> > I think the original argument for the current design was that with
> > enough nextval's you can duplicate the effect of a setval.  This is only
> > strictly true if the sequence is CYCLE mode, and even then it'd take a
> > whole lot of patience to wrap an int8 sequence around ... but the
> > distinction between them is not so large as you make it out to be.
> >
> > In any case I think we are wasting our time discussing it, and instead
> > should be looking through the SQL2003 spec to see what it requires.
> 
> 5WD-02-Foundation-2003-09.pdf
> 
> look at:
> 4.34.2 Privileges. . . . . . . . . . . . . . . . . . . . . . . . . . .
> . . . . . . . . . . . . 112
> and
> 12.3 <privileges>. . . . . . . . . . . . . . . . . . . . . . . . . . .
> . . . . . . . . . . . . 739
> 
> this is taken from the 12.3
> 
> 3) If <object name> specifies a <domain name>, <collation name>,
> <character set name>, <transliteration name>, <schema-resolved
> user-defined type name>, or <sequence generator name>, then
> <privileges> may specify USAGE. Otherwise, USAGE shall not be
> specified.

Yes, I saw that, but how does that hook into nextval/setval/currval()?
I think I see it in 6.13:

        a) If <next value expression> is contained in a <schema definition>,
        then the applicable privileges for the <authorization identifier> that
        owns the containing schema shall include USAGE privilege on the sequence
        generator identified by <sequence generator name>.

Is that it?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to