Null geometries for CREATE TABLE AS ... SELECT *

[Robert Hewlett]

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/7124ed65/attachment.htm>