From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: serial arrays? |
Date: | 2008-03-21 17:00:36 |
Message-ID: | 20080321100036.273055d9@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Fri, 21 Mar 2008 12:55:26 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2008-03-21 17:01:35 | Re: Auto Partitioning Patch - WIP version 1 |
Previous Message | Warren Turkal | 2008-03-21 16:55:33 | Re: [PATCH] Add TimeOffset and DateOffset typedefs |