Skip site navigation (1) Skip section navigation (2)

Re: tweak CREATE SEQUENCE grammar

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>,PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: tweak CREATE SEQUENCE grammar
Date: 2002-10-02 14:55:28
Message-ID: 200210021455.g92EtSi05180@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Neil Conway wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > Neil Conway writes:
> > > Can you point me to where in the standard these are defined? (I looked
> > > briefly but couldn't find it.)
> > 
> > The current value is set with ALTER SEQUENCE name RESTART WITH value;
> > (11.63).
> 
> Great, thanks for the info.
> 
> >  "serial" columns are defined like
> > 
> >     foo int GENERATED BY DEFAULT AS IDENTITY [(sequence options)]
> 
> Wow, that's verbose. I suppose it's still worth supporting, but you've
> got to wonder how the committee every arrived at that syntax...
> 
> Since it seems the SQL 200x stuff has the same semantics as the
> sequences we already have, I think this patch is still suitable for
> application (I'll fix some more of the syntax stuff later, I'll
> definately have time before 7.4) -- Bruce, can you add this back to
> the queue for 7.4?

Sure, would you shoot it over to me again?  Thanks.

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

In response to

Responses

pgsql-patches by date

Next:From: Neil ConwayDate: 2002-10-02 15:09:23
Subject: Re: tweak CREATE SEQUENCE grammar
Previous:From: Neil ConwayDate: 2002-10-02 14:45:32
Subject: Re: tweak CREATE SEQUENCE grammar

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group