> 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