On Fri, Mar 21, 2008 at 10:25 PM, Tom Lane <[EMAIL PROTECTED]> 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, -- [EMAIL PROTECTED] [EMAIL PROTECTED] 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