From: | Corey Horton <chorton1(at)austin(dot)rr(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 |
Date: | 2008-12-14 19:26:05 |
Message-ID: | 49455DCD.3030802@austin.rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
Is there any known workaround to get this the elements of the
histogram_bounds anyarray in 8.3.5. If not, when might I expect a fix?
Just trying to plan our testing/release schedule of rolling out to 8.3
around this problem.
Thanks,
Corey
Tom Lane wrote:
> I wrote:
>
>> While we could probably revert just enough of the changes to
>> enforce_generic_type_consistency to allow this case again, I wonder
>> just how safe that'd really be. It would amount to expecting that
>> functions that take anyarray but don't take or return anyelement to
>> not only work on any array type, but to be always prepared for the
>> input element type to change on-the-fly (since that's exactly what
>> would happen when scanning pg_statistic). Quite a lot of the built-in
>> anyarray functions are prepared to do that, but I'm not sure they all
>> are.
>>
>
> I went and looked, and found that none of the thirty or so built-in
> functions that accept ANYARRAY are coded to make unsafe assumptions
> about the input array type remaining the same across calls. So at least
> as of CVS HEAD, it seems safe to relax this back to the way it was
> pre-8.3.
>
> I'm still worried about the possibility of extension functions or future
> core functions failing to follow this coding rule; but as long as people
> are lazy and copy-and-paste from the existing models, it should be okay.
>
> regards, tom lane
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Mielke | 2008-12-14 19:44:39 | Re: Sync Rep: First Thoughts on Code |
Previous Message | Tom Lane | 2008-12-14 18:16:03 | Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-12-14 19:58:03 | Re: Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 |
Previous Message | Louis-David Mitterrand | 2008-12-14 19:22:13 | optimizing a query |