Re: Arrays of Complex Types

Alvaro Herrera wrote:
> David Fetter wrote:
>
>   
>> The first is in type_sanity, which basically doesn't understand that
>> complex types now have array types associated with them and thinks
>> they're orphan array types, so it's actually the test that's not
>> right.
>>     
>
> Hmm, I question the usefulness of automatically creating array types for
> all relation types that are created -- the catalog bloat seems a bit too
> much.  An array of pg_autovacuum for example, does that make sense?
>
> I'm not sure what was the reaction to having an "CREATE TYPE foo ARRAY
> OF bar" command of some kind?  I think this was discussed but not
> explicitely rejected, or was it?
>
>   

It certainly seems rather inconsistent to have array types autocreated 
for some types but not others. But unless we create them for all types 
then I think we need a command such as you suggest.

How much bloat will this really be? If it's not used it won't get into 
the type cache. I find it hard to believe there will be any very 
significant performance effect.

cheers

andrew