| From: | Chris <pghackers(at)designmagick(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | serial datatype changes for v7.3? |
| Date: | 2002-09-02 14:00:43 |
| Message-ID: | 3D736F0B.4090202@designmagick.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
I'm playing around with the CVS version and noticed a change from 7.2 in
regards to serial datatypes - they no longer automatically have an
index. Is this a deliberate thing? I did a search in the archives but
didn't come across mention of the change. A pointer to discussion on
this would be great.
CREATE TABLE author (
authorid SERIAL,
firstname VARCHAR(255),
surname VARCHAR(255),
dateofbirth DATE,
gender CHAR(1)
);
NOTICE: CREATE TABLE will create implicit sequence
'author_authorid_seq' for SERIAL column 'author.authorid'
CREATE TABLE
library=# \d author
Table "public.author"
Column | Type | Modifiers
-------------+------------------------+--------------------------------------------------------------
authorid | integer | not null default
nextval('public.author_authorid_seq'::text)
firstname | character varying(255) |
surname | character varying(255) |
dateofbirth | date |
gender | character(1) |
library=# \di
No relations found.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-09-02 14:33:49 | Re: I am done |
| Previous Message | Bruce Momjian | 2002-09-02 13:43:59 | Re: current build fail |