Re: [HACKERS] serial arrays?

2008-03-22 Thread Shane Ambler
Joshua D. Drake wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 21 Mar 2008 12:55:26 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: regression=# create table foo (f1 serial[11]); NOTICE: CREATE TABLE will create implicit sequence "foo_f1_seq" for serial column "foo.f1" CREATE TABLE re

Re: [HACKERS] serial arrays?

2008-03-21 Thread Gurjeet Singh
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 f

Re: [HACKERS] serial arrays?

2008-03-21 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 21 Mar 2008 12:55:26 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > 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

[HACKERS] serial arrays?

2008-03-21 Thread Tom Lane
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_