Thread: PostgreSQL 9.1beta 1 Some domains not being able to be auto cast to their base type
PostgreSQL 9.1beta 1 Some domains not being able to be auto cast to their base type
From
"Paragon Corporation"
Date:
In regression testing PostGIS 2.0, our topology module regression tests are failing in PostgreSQL 9.1 beta. We have a PostGIS ticket open for it here, but we suspect it's a PostgreSQL 9.1 bug and would like to close it out. http://trac.osgeo.org/postgis/ticket/980 Our domain type is defined as: CREATE DOMAIN topoelementarray AS integer[][] CONSTRAINT dimensions CHECK ((((array_upper(VALUE, 2) IS NOT NULL) AND (array_upper(VALUE, 2) = 2)) AND (array_upper(VALUE, 3) IS NULL))); If I try this in PostgreSQL 9.1 beta1: SELECT array_upper(ARRAY[ARRAY[1,2], ARRAY[3,4]]::topoelementarray,1); I get error: function array_upper(topoelementarray, integer) does not exist In my PostgreSQL 9.0 and 8.4 the above operation works fine. Thanks, Regina
Re: PostgreSQL 9.1beta 1 Some domains not being able to be auto cast to their base type
From
Craig Ringer
Date:
On 05/24/2011 07:05 PM, Paragon Corporation wrote: > In regression testing PostGIS 2.0, our topology module regression tests are > failing in PostgreSQL 9.1 beta. > > We have a PostGIS ticket open for it here, but we suspect it's a PostgreSQL > 9.1 bug and would like to close it out. Do you think you might be able to figure out how to boil it down to a test case without PostGIS? It might help show that it's a Pg bug more clearly. Just a quick reply because I notice you haven't had any responses. -- Craig Ringer
Re: PostgreSQL 9.1beta 1 Some domains not being able to be auto cast to their base type
From
Merlin Moncure
Date:
On Wed, May 25, 2011 at 7:37 AM, Craig Ringer <craig@postnewspapers.com.au> wrote: > On 05/24/2011 07:05 PM, Paragon Corporation wrote: >> >> In regression testing PostGIS 2.0, our topology module regression tests >> are >> failing in PostgreSQL 9.1 beta. >> >> We have a PostGIS ticket open for it here, but we suspect it's a >> PostgreSQL >> 9.1 bug and would like to close it out. > > Do you think you might be able to figure out how to boil it down to a test > case without PostGIS? It might help show that it's a Pg bug more clearly. > > Just a quick reply because I notice you haven't had any responses. This issue is known and is going to be addressed -- see recent threads on -hackers regarding arrays of domains. merlin
Re: PostgreSQL 9.1beta 1 Some domains not being able to be auto cast to their base type
From
Merlin Moncure
Date:
On Wed, May 25, 2011 at 9:06 AM, Merlin Moncure <mmoncure@gmail.com> wrote: > On Wed, May 25, 2011 at 7:37 AM, Craig Ringer > <craig@postnewspapers.com.au> wrote: >> On 05/24/2011 07:05 PM, Paragon Corporation wrote: >>> >>> In regression testing PostGIS 2.0, our topology module regression tests >>> are >>> failing in PostgreSQL 9.1 beta. >>> >>> We have a PostGIS ticket open for it here, but we suspect it's a >>> PostgreSQL >>> 9.1 bug and would like to close it out. >> >> Do you think you might be able to figure out how to boil it down to a test >> case without PostGIS? It might help show that it's a Pg bug more clearly. >> >> Just a quick reply because I notice you haven't had any responses. > > > This issue is known and is going to be addressed -- see recent threads > on -hackers regarding arrays of domains. er, domains of arrays :-). merlin