From:
Bruce Momjian <bruce(at)momjian(dot)us>
To:
David Fetter <david(at)fetter(dot)org>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,
PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>,
PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: [HACKERS] Arrays of Complex Types
Date:
2007-04-03 00:28:15
Message-ID:
200704030028.l330SFp03048@momjian.us (view raw or flat )
Thread:
2007-03-02 23:40:16 from David Fetter <david(at)fetter(dot)org>
2007-03-02 23:59:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-03 00:42:14 from "Andrew Dunstan" <andrew(at)dunslane(dot)net>
2007-03-03 13:14:57 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2007-03-03 14:06:11 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-03-03 17:25:23 from David Fetter <david(at)fetter(dot)org>
2007-03-03 17:45:32 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-03-04 00:48:38 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-03-06 21:05:56 from David Fetter <david(at)fetter(dot)org>
2007-03-06 21:14:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-06 21:17:41 from David Fetter <david(at)fetter(dot)org>
2007-03-06 21:24:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-06 21:27:12 from David Fetter <david(at)fetter(dot)org>
2007-03-26 01:31:58 from David Fetter <david(at)fetter(dot)org>
2007-03-26 02:18:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-27 18:08:44 from David Fetter <david(at)fetter(dot)org>
2007-03-27 19:39:04 from David Fetter <david(at)fetter(dot)org>
2007-03-27 21:04:39 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-03-28 07:05:24 from Andrew - Supernews <andrew+nonews(at)supernews(dot)com>
2007-03-28 16:57:38 from David Fetter <david(at)fetter(dot)org>
2007-03-28 17:11:05 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-03-28 17:33:56 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-03-28 18:48:57 from David Fetter <david(at)fetter(dot)org>
2007-03-28 17:35:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-28 19:15:20 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-03-28 19:24:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-28 19:41:07 from David Fetter <david(at)fetter(dot)org>
2007-03-30 20:23:58 from David Fetter <david(at)fetter(dot)org>
2007-03-30 21:08:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-31 23:10:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-31 23:13:20 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-03-31 23:36:21 from David Fetter <david(at)fetter(dot)org>
2007-03-31 23:58:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-04-01 00:22:18 from David Fetter <david(at)fetter(dot)org>
2007-04-01 00:28:54 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-04-01 02:31:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-04-01 07:40:09 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-04-01 07:50:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-04-01 08:15:29 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-04-01 09:36:39 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-04-01 10:04:06 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-04-01 18:31:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-04-01 20:18:57 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-04-02 04:11:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-04-02 20:10:05 from David Fetter <david(at)fetter(dot)org>
2007-04-03 00:28:15 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-04-03 02:01:44 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-04-03 06:10:13 from David Fetter <david(at)fetter(dot)org>
2007-04-03 06:30:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-04-03 13:29:23 from David Fetter <david(at)fetter(dot)org>
2007-04-03 14:20:44 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-04-08 22:47:44 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-04-08 23:08:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-04-08 23:32:22 from David Fetter <david(at)fetter(dot)org>
2007-04-08 23:36:17 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-04-09 00:09:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-04-09 00:35:53 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-04-09 00:41:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-04-09 01:53:46 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-04-09 02:24:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-04-09 14:14:41 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-04-09 14:40:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-04-09 16:39:36 from David Fetter <david(at)fetter(dot)org>
2007-04-09 19:57:34 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2007-04-09 20:07:16 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-04-09 21:12:24 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2007-05-06 17:33:47 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-05-06 17:47:32 from David Fetter <david(at)fetter(dot)org>
2007-05-11 18:27:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-05-11 20:19:51 from "Merlin Moncure" <mmoncure(at)gmail(dot)com>
Lists:
pgsql-hackers pgsql-patches
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.
---------------------------------------------------------------------------
David Fetter wrote:
> On Fri, Mar 30, 2007 at 05:08:42PM -0400, Tom Lane wrote:
> > David Fetter <david(at)fetter(dot)org> writes:
> > > After several rounds of patches, it appears that it might be easier to
> > > create a new typtype entry, which I'll tentatively call 'a' because it
> > > seems a little fragile and a lot inelegant and hard to maintain to
> > > have typtype='c' and typrelid=InvalidOid mean, "this is an array of
> > > complex types."
> >
> > Uh, wouldn't it be typtype = 'c' and typelem != 0 ?
>
> Right. The attached patch passes the current regression tests and at
> least to a "smoke test" level does what it's supposed to do. I'd
> really like to help refactor the whole array system to use 'a', tho.
>
> Cheers,
> D
> --
> David Fetter <david(at)fetter(dot)org> http://fetter.org/
> phone: +1 415 235 3778 AIM: dfetter666
> Skype: davidfetter
>
> Remember to vote!
> Consider donating to PostgreSQL: http://www.postgresql.org/about/donate
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
In response to
Responses
pgsql-hackers by date
Next :From: ITAGAKI TakahiroDate: 2007-04-03 00:52:32
Subject : Re: CheckpointStartLock starvation
Previous :From : Gavin SherryDate : 2007-04-03 00:03:40
Subject : Re: Many unfinished patches
pgsql-patches by date
Next :From: Bruce MomjianDate: 2007-04-03 01:06:17
Subject : Re: ecpg threading vs win32
Previous :From : Bruce MomjianDate : 2007-04-03 00:27:27
Subject : Re: RESET SESSION