Gregory Stark <stark@enterprisedb.com> writes:
> "Tom Lane" <tgl@sss.pgh.pa.us> writes:
>> CREATE ARRAY TYPE FOR foo
> I also made a suggestion along the way that we never create array types
> automatically except for domains.
That seems awfully strange, not to mention very non-backwards-compatible
since it exactly reverses what happens now.
I'd be willing to consider it if a domain were a zero-cost addition to
the equation, but it is not --- every operation on a domain has to check
to see if there are constraints to enforce. You shouldn't have to buy
into that overhead to have an array.
regards, tom lane