Re: serial arrays? - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: serial arrays?
Date
Msg-id 20080321100036.273055d9@commandprompt.com
Whole thread Raw
In response to serial arrays?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: serial arrays?  (Shane Ambler <pgsql@Sheeky.Biz>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 21 Mar 2008 12:55:26 -0400
Tom Lane <tgl@sss.pgh.pa.us> 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-----

pgsql-hackers by date:

Previous
From: "Warren Turkal"
Date:
Subject: Re: [PATCH] Add TimeOffset and DateOffset typedefs
Next
From: "Gurjeet Singh"
Date:
Subject: Re: serial arrays?