serial arrays?
От | Tom Lane |
---|---|
Тема | serial arrays? |
Дата | |
Msg-id | 25588.1206118526@sss.pgh.pa.us обсуждение исходный текст |
Ответы |
Re: serial arrays?
Re: serial arrays? |
Список | 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 по дате отправления: