From: | Andreas Zeugswetter <andreas(dot)zeugswetter(at)telecom(dot)at> |
---|---|
To: | "'lockhart(at)alumni(dot)caltech(dot)edu'" <lockhart(at)alumni(dot)caltech(dot)edu> |
Cc: | PostgreSQL-development <hackers(at)postgreSQL(dot)org> |
Subject: | AW: [HACKERS] sequence creation |
Date: | 1998-08-19 09:00:25 |
Message-ID: | 01BDCB61.4EE5EF40@zeugswettera.user.lan.at |
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);
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
exactly this. :-) (like in Informix)
Informix also allows to specify a starting value like:
create table t (s serial(1000));
defaulting to 1 but I think this additional syntax is rather misleading
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Maarten Boekhold | 1998-08-19 09:14:15 | Re: [HACKERS] What does "cannot extend" mean? |
Previous Message | Dr. Michael Meskes | 1998-08-19 08:27:42 | initb won't work |