Null geometries for CREATE TABLE AS ... SELECT *

Robert Hewlett <[email protected]>
Newsgroups gmane.comp.gis.postgis
Message-ID <CAG_Q50RjWHYgYubHFx4eqcHkfcvLKcRUpFroVFz1NRiPa=_+RA@mail.gmail.com>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.