Null geometries for CREATE TABLE AS ... SELECT *

[Regina Obe]

You confirmed that your source table has no NULL geometries?

 

From: Robert Hewlett <rob.hewy at gmail.com> 
Sent: Wednesday, October 23, 2024 9:17 AM
To: postgis-users at lists.osgeo.org
Subject: Null geometries for CREATE TABLE AS ... SELECT *

 

Hi,

 

Any reason or thoughts on why CREATE TABLE AS ... SELECT * would result in the geom column having null geometries?

 

Seems to affect POINT; POLYGON was okay

 

PostgreSQL 16.4 (Ubuntu 16.4-0ubuntu0.24.04.2) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.2.0-23ubuntu4) 13.2.0, 64-bit

 

"POSTGIS=""3.4.2 c19ce56"" [EXTENSION] PGSQL=""160"" GEOS=""3.12.1-CAPI-1.18.1"" SFCGAL=""SFCGAL 1.5.1, CGAL 5.6, BOOST 1.83.0"" PROJ=""9.4.0 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org USER_WRITABLE_DIRECTORY=/tmp/proj DATABASE_PATH=/usr/share/proj/proj.db"" GDAL=""GDAL 3.8.4, released 2024/02/08"" LIBXML=""2.9.14"" LIBJSON=""0.17"" LIBPROTOBUF=""1.4.1"" WAGYU=""0.5.0 (Internal)"" TOPOLOGY RASTER"

 

Thanks,

 

Rob

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20241023/2f9a286f/attachment.htm>