I would first check how many clusters you have and versions with below command:
pg_lsclusters
Ver Cluster Port Status OwnerData directory Log file
12 main5432 online postgres /var/lib/postgresql/12/main
/var/log/postgresql/postgresql-12-main.log
No problems there.
Chec
but are bound to a in-development
binary. If you ran it already, it's still okay cause all the upgrade scripts
are copies of each other.
> -Original Message-
> From: Regina Obe [mailto:l...@pcorp.us]
> Sent: Sunday, November 28, 2021 12:27 PM
> To: 'PostGIS Users Dis
lf
> Of Jonathan Schultz
> Sent: Sunday, November 28, 2021 7:50 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] ST_Union on empty polygon loses SRID
>
> This is actually in response to Regina Obe's email which I didn't receive but
> only saw on the l
This is actually in response to Regina Obe's email which I didn't
receive but only saw on the list archives. Maybe there is another way of
replying to her message but I don't know it.
I have definitely upgraded my debian/unstable installation.
> $ dpkg-query -W postgis
> postgis 3.1.4+dfsg-3+b
gt; To: Darafei "Kom?pa" Praliaskouski
> Cc: PostGIS Users Discussion
> Subject: Re: [postgis-users] ST_Union on empty polygon loses SRID
>
> Thanks for the quick response!
>
> > => select
Thanks for the quick response!
=> select postgis_full_version();
postgis_full_version
---
Does not reproduce on my 3.2 and 3.1.4 installs:
10:17:37 [gis] > select postgis_full_version();
┌
Hello,
I have found with a query that makes a union of geometries which
includes an empty polygon produces a result without an SRID. For a
trivial example:
> => select ST_SRID(ST_Union(ST_GeomFromText('POLYGON EMPTY', 4283)));
> st_srid -
>0
This seems like a bug to me but m
