-----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 > 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? Interesting? Would be to create 11 sequences that can update each element of the array. Sane? None. We should throw an error. Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFH4+m0ATb/zqfZUUQRAhNgAKCR9dM4lw7Wu7p1OMHm7ESWi25gxwCgqUuL RkTa6gZqUqUXTlM6h97nf30= =bwi3 -----END PGP SIGNATURE----- -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers