[postgis-users] ST_Union on empty polygon loses SRID

[Regina Obe]

You sure that is fresh from debian unstable.

PostGIS 3.1.0alpha1 was more than a year ago.  Latest stable release for 3.1
is PostGIS 3.1.4 which is newer than what you are showing below.

I think debian unstable is carrying 3.2.0beta1 and will be carrying
3.2.0beta2 soon.

Also your procs are out of date.

Try running 

SELECT postgis_extensions_upgrade();

And then test again to see if things are better.

> -----Original Message-----
> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On
Behalf
> Of Jonathan Schultz
> Sent: Saturday, November 27, 2021 5:43 AM
> To: Darafei "Kom?pa" Praliaskouski <me at komzpa.net>
> Cc: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> Subject: Re: [postgis-users] ST_Union on empty polygon loses SRID
> 
> Thanks for the quick response!
> 
> > => select postgis_full_version();
> >
postgis_full_version
> > ----------------------------------------------------------------------
> > ----------------------------------------------------------------------
> > ----------------------------------------------------------------------
> > ---------
> >  POSTGIS="3.1.0alpha1 f7a3648" [EXTENSION] PGSQL="120"
> > GEOS="3.10.1-CAPI-1.16.0" PROJ="7.2.1" LIBXML="2.9.10"
> > LIBJSON="0.13.1" LIBPROTOBUF="1.3.3" WAGYU="0.4.3 (Internal)" (core
> > procs from "3.0.2 2fb2a18" need upgrade)
> 
> This is from Debian/unstable. Looks like I just need to wait for an update
and
> the problem will go away.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users