Re: [postgis-users] Help resolving raster2pgsql error

2021-06-22 Thread Regina Obe
> On Wed, 23 Jun 2021 at 08:32, Ben Boughton wrote: > > Processing 1/1: testr.tif > > ERROR 1: PROJ: proj_as_wkt: SQLite error on SELECT name, > > ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, > > prime_meridian_code, area_of_use_auth_name, area_of_use_code, > > publication_date,

Re: [postgis-users] Help resolving raster2pgsql error

2021-06-22 Thread Mike Taves
On Wed, 23 Jun 2021 at 08:32, Ben Boughton wrote: > Processing 1/1: testr.tif > ERROR 1: PROJ: proj_as_wkt: SQLite error on SELECT name, ellipsoid_auth_name, > ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, > area_of_use_auth_name, area_of_use_code, publication_date, deprecated F

Re: [postgis-users] Help resolving raster2pgsql error

2021-06-22 Thread Komяpa
Your Proj installation seems broken. аў, 22 чэр 2021, 23:32 карыстальнік Ben Boughton напісаў: > I am having issues loading raster via raster2pgsql (RELEASE: 3.1.2 > GDAL_VERSION=30 (cbe925d)); postgres (PostgreSQL) 13.3 (Ubuntu > 13.3-1.pgdg20.04+1) > > If I run: > > raster2pgsql -C -R testr.ti

[postgis-users] Help resolving raster2pgsql error

2021-06-22 Thread Ben Boughton
I am having issues loading raster via raster2pgsql (RELEASE: 3.1.2 GDAL_VERSION=30 (cbe925d)); postgres (PostgreSQL) 13.3 (Ubuntu 13.3-1.pgdg20.04+1) If I run: raster2pgsql -C -R testr.tif testr > out.sql Output: Processing 1/1: testr.tif ERROR 1: PROJ: proj_as_wkt: SQLite error on SELECT name,

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

2021-06-22 Thread Rhys A.D. Stewart
Greetings All, Firstly, apologies for cross posting. I would like to create a table which will contain postGIS geometries, specifically linestrings. Each line string should be unique, unique in the sense that no linestring should st_equals any other. (see https://postgis.net/docs/manual-3.1/ST_Eq