PostgreSQL 9.1beta 1 Some domains not being able to be auto cast to their base type

From: "Paragon Corporation" <lr(at)pcorp(dot)us>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: PostgreSQL 9.1beta 1 Some domains not being able to be auto cast to their base type
Date: 2011-05-24 11:05:22
Message-ID: FE9FFC6BE9F84968846C66FF4A22AE1E@J
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message manish singh 2011-05-24 15:27:32 BUG #6037: error on restarting slave - cp: cannot stat `pg_xlog....`: no such file or ...
Previous Message jose soares 2011-05-24 07:14:33 BUG #6036: why a REAL should be queried as a string?