From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | PostgreSQL-development <hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] sequence creation |
Date: | 1998-08-19 02:35:41 |
Message-ID: | 35DA39FD.CBA5915C@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | D'Arcy J.M. Cain | 1998-08-19 03:12:18 | Re: [HACKERS] sequence creation\ |
Previous Message | Bruce Momjian | 1998-08-19 02:35:12 | Re: [HACKERS] sequence creation |