Re: [postgis-users] Help resolving raster2pgsql error

2021-06-23 Thread Ben Boughton
I tried a clean install - this time with the UbuntuGIS-Unstable and just did 'apt get install postgis' - I got postgis3 and postgresql12 and raster2pgsql working. Ben Boughton On Wed, 23 Jun 2021 at 11:19, Regina Obe wrote: > > On Wed, 23 Jun 2021 at 08:32, Ben Boughton wrote: > > > Process

Re: [postgis-users] Help resolving raster2pgsql error

2021-06-23 Thread Ben Boughton
I did a fresh install on Ubuntu 20.04 of postgresql-13-postgis-3 followed by apt install postgis to get raster2pgsql I have the same problem. It appears that postgresql-13-postgis-3 depends on libproj15 > 6 and postgis depends on libproj15 > 4.9 - would this be the problem? If so, how do I go ab

Re: [postgis-users] Help resolving raster2pgsql error

2021-06-23 Thread Ben Boughton
Thanks - sounds complicated. I am running a fair bit of different stuff on the one remote server - including an install of QGIS and POSTGIS. I might just spin up a tiny unique environment to get this job done, save messing up other things that rely on proj. Ben Boughton On Wed, 23 Jun 2021 at

Re: [postgis-users] Exclusion constraint with custom operator not working as expected

2021-06-23 Thread Komяpa
Hello, The reason why constraint is not working is that GIST scan using your operator does not return what you expect. Deeper debugging needed on your side to fix that select to return the rows you need. 12:23:37 [kom] > explain select * from test_1 where g |*| 'LINESTRING(10 10,50 50)'; ┌──