Re: 4.1beta1: ANYARRAY disallowed for DOMAIN types which happen to be arrays - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 4.1beta1: ANYARRAY disallowed for DOMAIN types which happen to be arrays
Date
Msg-id 28245.1305049930@sss.pgh.pa.us
Whole thread Raw
In response to Re: 4.1beta1: ANYARRAY disallowed for DOMAIN types which happen to be arrays  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: 4.1beta1: ANYARRAY disallowed for DOMAIN types which happen to be arrays
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, May 9, 2011 at 11:32 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> So we basically had three alternatives to make it better:
>>        * downcast to the array type, which would possibly silently
>>          break applications that were relying on the function result
>>          being considered of the domain type
>>        * re-apply domain checks on the function result, which would be
>>          a performance hit and possibly again result in unobvious
>>          breakage
>>        * explicitly break it by throwing a parse error until you
>>          downcast (and then upcast the function result if you want)
>> I realize that #3 is a bit unpleasant, but are either of the other two
>> better?  At least #3 shows you where you need to check for problems.

> Aren't any applications that would be broken by #1 broken already?

My point is that doing #1 would break them *silently* --- if you did
have a problem, figuring out what it was could require a great deal
of sleuthing.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: collateral benefits of a crash-safe visibility map
Next
From: Robert Haas
Date:
Subject: Re: 4.1beta1: ANYARRAY disallowed for DOMAIN types which happen to be arrays