[postgis-devel] [PostGIS] #674: PostgreSQL 9.1 aggregation error

PostGIS trac at osgeo.org
Wed Dec 1 17:28:20 PST 2010


#674: PostgreSQL 9.1 aggregation error
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
 This only seems to fail in my 9.1 alpha1 build.  I'm trying to think the
 last time I tested my garden tests on 9.1.  I'm going to test my older
 binaries to see if they work or not and report back.

 Anyrate:


 {{{
 SELECT ST_Collect(geom)  As the_geom
                 FROM (VALUES (
 ST_GeomFromEWKT('SRID=4326;MULTIPOLYGON(((-71.0821 42.3036 2,-71.0822
 42.3036 2,-71.082 42.3038 2,-71.0819 42.3037 2,-71.0821 42.3036 2)))') ),
         ( ST_GeomFromEWKT('SRID=4326;POLYGON((-71.1261 42.2703 1,-71.1257
 42.2703 1,-71.1257 42.2701 1,-71.126 42.2701 1,-71.1261 42.2702 1,-71.1261
 42.2703 1))') )
                 )       As g(geom) CROSS JOIN generate_series(1,3) As i
                 GROUP BY i;
 }}}

 On my 9.1 Alpha1 VC++ windows build fails with:


 {{{
 ERROR:  array_agg_transfn called in non-aggregate context

 ********** Error **********

 ERROR: array_agg_transfn called in non-aggregate context
 SQL state: XX000


 }}}

 I think its a bug in our code, because I can do this:


 {{{
 SELECT array_agg(1) As dummy_one
                 FROM (VALUES (
 ST_GeomFromEWKT('SRID=4326;MULTIPOLYGON(((-71.0821 42.3036 2,-71.0822
 42.3036 2,-71.082 42.3038 2,-71.0819 42.3037 2,-71.0821 42.3036 2)))') ),
         ( ST_GeomFromEWKT('SRID=4326;POLYGON((-71.1261 42.2703 1,-71.1257
 42.2703 1,-71.1257 42.2701 1,-71.126 42.2701 1,-71.1261 42.2702 1,-71.1261
 42.2703 1))') )
                 )       As g(geom) CROSS JOIN generate_series(1,3) As i
                 GROUP BY i

 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/674>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list