[postgis-devel] gserialized-v2

Paul Ramsey pramsey at cleverelephant.ca
Mon Jun 24 12:00:31 PDT 2019



> On Jun 22, 2019, at 9:31 AM, Sandro Santilli <strk at kbt.io> wrote:
> 
> On Sat, Jun 22, 2019 at 08:37:48AM -0700, Paul Ramsey wrote:
> 
>>>  3. Use `UPDATE mytable SET geom = ST_Noop(geom)` to force all things to v2
>> 
>> The minimal thing required to cause a re-write is
>> deserialize/serialize, which is not *quite* a no-op.
> 
> Uhm... I'm pretty sure we did deserialize/serialize in ST_Noop, on
> purpose. And we have (had?) ST_GeosNoop() to include geos
> deserialization/serialization too (and ST_SfcgalNoop for same reason)…

Confirmed, postgis_noop() in SQL does exactly what you want (LWGEOM_noop in c), so it’ll force a rewrite in the new format.

P.



More information about the postgis-devel mailing list