Re: serial arrays?

Поиск
Список
Период
Сортировка
От Gurjeet Singh
Тема Re: serial arrays?
Дата
Msg-id 65937bea0803211005i591332cfkcb44879fbf4272da@mail.gmail.com
обсуждение исходный текст
Ответ на serial arrays?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Fri, Mar 21, 2008 at 10:25 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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?

+1
 
If not, what behavior would be
sane?


I don't see any sane explanation if we do provide that syntax!!!

Best regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

17° 29' 34.37"N, 78° 30' 59.76"E - Hyderabad *
18° 32' 57.25"N, 73° 56' 25.42"E - Pune
37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco

http://gurjeet.frihost.net

Mail sent from my BlackLaptop device

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: serial arrays?
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Commit Fest (was Re: Sort Refinement)