Re: [Geoserver-users] "org.postgresql.util.PSQLException" in geoserver 2.21.2 (not in 2.21.1)

2022-11-24 Thread Niels Charlier via Geoserver-users
Hello everyone, Thank you for bringing to attention the regression caused by the fix for GEOT-7248. Part of the purpose of this fix was actually to cover the case of multiple columns, which were in previous version not handled properly either. There was indeed no exception, but the count was n

Re: [Geoserver-users] "org.postgresql.util.PSQLException" in geoserver 2.21.2 (not in 2.21.1)

2022-11-24 Thread Hans Yperman
I don’t think geoserver's behaviour is correct, so maybe it's worth logging an issue. I've also wondered why they don't simply use SELECT COUNT(*) and don't mention the column names. The code would be much simpler and always correct independent of the number of columns. It might return a diff

Re: [Geoserver-users] "org.postgresql.util.PSQLException" in geoserver 2.21.2 (not in 2.21.1)

2022-11-24 Thread Niels Charlier via Geoserver-users
Hello Hans, App-schema supports the use of denormalized views. In this usecase ID's are not unique and multiple rows with the same id are combined and used to create single complex feature. In this use case COUNT(*) would not give the correct result. Kind Regards Niels On 24/11/2022 09:05,

[Geoserver-users] SQL Server points layer always classified as "Other Geometry" and GSR/ArcGIS read it as polygon?

2022-11-24 Thread Patricia Kneen
Good afternoon. I am trying to figure out how to publish my SQL Server point data in Geoserver as Points, rather than "Other Geometry". I have tried with many versions of Geoserver (2.15 - 2.22) and a whole variety of options, but I cannot seem to convince Geoserver that the layer contains regu