Questions tagged [postgresql-14]
The postgresql-14 tag has no usage guidance.
6
questions
1
vote
0
answers
61
views
PostGIS ogr_fdw foreign data wrapper ERROR: column "date" of foreign table 'mytable' converts OGR "String" to "date"
Using the ogr_fdw extension on PG 14 PostGIS 3.2 on Ubuntu 22.04.1 LTS, I am trying to register a foreign table in my local PostgreSQL database based on an OGC API Feature endpoint serving GeoJSON ...
- 9,363
0
votes
0
answers
295
views
PostgreSQL error 42601 when trying to access stored procedure with prepared query from PyQt5 using QPSQL driver
I'm trying to use PostGIS as a backend for a QGIS system. I Just started with PostgreSQL and run into difficulties running a store procedure from a PyQt5 client using (this time) the QPSQL driver. I ...
- 243
0
votes
0
answers
59
views
Calling procedure from PyQt5 using psycopg2 driver PostgreSQL Error 2D000 Invalid transaction termination
I'm trying to use PostGIS as a backend for a QGIS system. I started with PostgreSQL recently and I'm running into trouble calling a procedure from a PyQt5 client using the psycopg2 driver.
I set a ...
- 243
3
votes
0
answers
263
views
Storing a large 3D TIN into a PostGIS database
I have to store a massive TIN (1.5 GB) into a PostGIS database to do some computations with it.
After my first try, I was getting a "server closed the connection unexpectedly" issue when ...
- 9,363
0
votes
1
answer
171
views
PostGIS SFCGAL ERROR: PolyhedralSurface is invalid : inconsistent orientation of PolyhedralSurface detected at edge 0 (0-1) of polygon 3
I am trying to tesselate (yes, in the following case the tessellation is perfectly useless, but it's for the purpose of the example), with the help of ST_Tesselate() from SFCGAL, a polyhedral surface ...
- 9,363
2
votes
0
answers
846
views
How to write Shapely polygons (or a multipolygon) to a PostGIS polyhedralsurface
Context
In a Python script, I have a 3D square pyramid composed of 4 triangles (a list of 4 Shapely 3D polygons) that I need to store within a PostgreSQL database (+PostGIS).
Here's what this pyramid ...
- 9,363