From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | David Fetter <david(at)fetter(dot)org>, PG Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Arrays of Complex Types |
Date: | 2007-03-03 14:06:11 |
Message-ID: | 45E980D3.9000205@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Martijn van Oosterhout wrote:
> On Fri, Mar 02, 2007 at 06:42:14PM -0600, Andrew Dunstan wrote:
>
>>> I'm still not happy about the idea of doing this for every relation
>>> (and doing it for sequences and indexes would be the height of
>>> wastefulness). How about we only do it for composite types?
>>>
>> I'm not happy about that. I agree that indexes and sequences should not be
>> done, but can we please do plain table types? I would be OK if we skipped
>> catalog tables, if that would make you happier.
>>
>
> Two thoughts:
>
> 1. Make the array types only when someone actually uses them (create a
> table with it or something).
>
> 2. Make a command: CREATE TYPE ARRAY OF "foo";
>
> The latter has the benefit of not restricting it to an arbitrary choice
> of types, you could accept both domains and composite types here. I
> don't think it's unreasonable to require people to predeclare their
> usage of array-of-compostite-type.
>
> Perhaps change the word "CREATE" to "DECLARE". I'm thinking of the
> explicit declaration of shell types as precedent here.
>
>
>
#2 would be fine with me - not keen on #1.
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2007-03-03 14:10:32 | Re: PostgreSQL - 'SKYLINE OF' clause added! |
Previous Message | Martijn van Oosterhout | 2007-03-03 13:40:52 | Re: PostgreSQL - 'SKYLINE OF' clause added! |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-03-03 16:23:09 | Re: resetStringInfo |
Previous Message | Martijn van Oosterhout | 2007-03-03 13:14:57 | Re: Arrays of Complex Types |