Re: [HACKERS] sequence creation

> Right now, we allow PRIMARY to auto-create an index.
> Can we have something to auto-create sequences, instead of the more
> complicated CREATE SEQUENCE process.
> Perhaps use the data type SERIAL to autocreate a sequence.  Should
> make life easier for novices.  We are getting too many sequence
> questions.

That would be possible. I'd be happier doing it for v6.5, since I'm
hoping to work on docs in the meantime. Of course, maybe it would be
easy :)

What should the syntax be exactly?

  CREATE TABLE t (s SERIAL);

or

  CREATE TABLE t (i INT DEFAULT SERIAL);

or ??

Are there alternate syntaxes from other DBs which should be considered?

                      - Tom