Best option is to add a check on column sizes. Regards,
David On Wed, 9 Aug 2023 at 21:39, Shaozhong SHI <[email protected]> wrote: > Regina, > > What is the robust way to do the following? > > If exists (select * from t) then > insert into a_table select * from t > End if; > > > This is trying to not to insert with no content. > > Regards, > > David > > On Wed, 9 Aug 2023 at 15:04, Regina Obe <[email protected]> wrote: > >> Your version should have those functions available since these functions >> came in PostGIS 3.1 and your GEOS is newer than 3.9 >> >> >> >> https://postgis.net/docs/manual-3.2/ST_Union.html >> >> >> >> Do you get an error when you run ST_Union with a gridsize? If so maybe >> your GEOS might be newer but you compiled with a lower version of GEOS. >> >> >> >> *From:* postgis-users [mailto:[email protected]] *On >> Behalf Of *Shaozhong SHI >> *Sent:* Wednesday, August 9, 2023 1:40 AM >> *To:* PostGIS Users Discussion <[email protected]> >> *Subject:* Re: [postgis-users] Size of geometry issue >> >> >> >> >> >> >> >> On Wed, 9 Aug 2023 at 04:30, Regina Obe <[email protected]> wrote: >> >> What is output of your >> >> >> >> SELECT postgis_full_version(); >> >> >> >> It is: >> >> >> >> POSTGIS="3.1.9 95a641b" [EXTENSION] PGSQL="130" GEOS="3.10.3-CAPI-1.16.1" >> SFCGAL="1.3.1" PROJ="7.2.1" LIBXML="2.9.1" LIBJSON="0.11" (core procs from >> "3.1.4 ded6c34" need upgrade) (sfcgal procs from "3.1.4 ded6c34" need >> upgrade) >> >> >> >> Regards, >> >> >> >> David >> >> >> >> >> >> *From:* postgis-users [mailto:[email protected]] *On >> Behalf Of *Shaozhong SHI >> *Sent:* Tuesday, August 8, 2023 6:49 PM >> *To:* PostGIS Users Discussion <[email protected]> >> *Subject:* Re: [postgis-users] Size of geometry issue >> >> >> >> Hi, Regina, >> >> It did not work. >> >> Regards, David >> >> On Tuesday, 8 August 2023, Regina Obe <[email protected]> wrote: >> >> Are you running GEOS > 3.9. >> >> >> >> If so maybe ST_Union with a gridsize might work better for you needs over >> ST_Collect >> >> >> >> https://postgis.net/docs/ST_Union.html >> >> >> >> There are also a number of precision reduction functions >> >> >> >> https://postgis.net/docs/ST_SimplifyPreserveTopology.html >> >> https://postgis.net/docs/ST_SnapToGrid.html >> >> >> >> come to mind >> >> >> >> >> >> >> >> *From:* postgis-users [mailto:[email protected]] *On >> Behalf Of *Shaozhong SHI >> *Sent:* Tuesday, August 8, 2023 5:46 PM >> *To:* PostGIS Users Discussion <[email protected]> >> *Subject:* [postgis-users] Size of geometry issue >> >> >> >> St_collect is used and size issue may cause the problem. >> >> >> >> If just their relationship needs to be depicted, how can the size of >> geometry be reduced? >> >> >> >> Regards, >> >> >> >> David >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> https://lists.osgeo.org/mailman/listinfo/postgis-users >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> https://lists.osgeo.org/mailman/listinfo/postgis-users >> >
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
