serial arrays? - Mailing list pgsql-hackers

From Tom Lane
Subject serial arrays?
Date
Msg-id 25588.1206118526@sss.pgh.pa.us
Whole thread Raw
Responses Re: serial arrays?
Re: serial arrays?
List pgsql-hackers
A recent message from a would-be mysql converter led me to realize
that we don't check for array decoration when we expand "serial".
So this is accepted but doesn't do what one might expect:

regression=# create table foo (f1 serial[11]);
NOTICE:  CREATE TABLE will create implicit sequence "foo_f1_seq" for serial column "foo.f1"
CREATE TABLE
regression=# \d foo                        Table "public.foo"Column |  Type   |                    Modifiers
        
 
--------+---------+--------------------------------------------------f1     | integer | not null default
nextval('foo_f1_seq'::regclass)


Should we throw an error for this?  If not, what behavior would be
sane?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Warren Turkal"
Date:
Subject: Re: timestamp datatype cleanup
Next
From: "Warren Turkal"
Date:
Subject: Re: [PATCH] Add TimeOffset and DateOffset typedefs