[postgis-users] ST_Union and 8.3?

[William Temperley]

Hello all

I'm having problems with ST_Union.

I get the error:
ERROR: Operation on mixed SRID geometries
SQL state: XX000

With the queries:
select st_union(the_geom) from tiles
select st_union(st_transform(the_geom, 4326)) from tiles

The second query cannot possibly have mixed srids!

st_collect works fine.
I've tried isvalid() and all is valid.
This works on the production server fine.

My version:
"1.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"
"PostgreSQL 8.3.0, compiled by Visual C++ build 1400"

Example inserts below:

insert into tiles values('2016~1326',
SetSRID(st_makebox2d(st_makepoint(-2.8125,53.38332836757156),st_makepoint(-2.724609375,
53.4357192066942)), 4326));insert into tiles values('2016~1327',
SetSRID(st_makebox2d(st_makepoint(-2.8125,53.33087298301704),st_makepoint(-2.724609375,
53.38332836757156)), 4326))

Any ideas what's wrong here?

Cheers

Will