RE: Null geometries for CREATE TABLE AS ... SELECT *
"Regina Obe" <[email protected]>
| Newsgroups | gmane.comp.gis.postgis |
|---|---|
| Message-ID | <[email protected]> |
You confirmed that your source table has no NULL geometries? From: Robert Hewlett <[email protected]> Sent: Wednesday, October 23, 2024 9:17 AM To: [email protected] 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