Re: [postgis-users] Topology - RemoveUnusedPrimitives workflow

2023-11-08 Thread Sandro Santilli via postgis-users
On Wed, Nov 08, 2023 at 10:05:39AM +, Alexandre Neto wrote: > Thanks Sandro, I will. And I will try to PR on the documentation. > > One extra question. When I add a topoGeometry column to a table with a > geometry column, in QGIS, I now fail to be able to edit the table. It seems > that the

Re: [postgis-users] Topology - RemoveUnusedPrimitives workflow

2023-11-08 Thread Alexandre Neto via postgis-users
Thanks Sandro, I will. And I will try to PR on the documentation. One extra question. When I add a topoGeometry column to a table with a geometry column, in QGIS, I now fail to be able to edit the table. It seems that the PostGIS provider forces me to use a key called tid. Nevertheless, I can't

Re: [postgis-users] Topology - RemoveUnusedPrimitives workflow

2023-11-07 Thread Sandro Santilli via postgis-users
On November 7, 2023 12:40:47 PM GMT+01:00, Alexandre Neto wrote: >Hi Sandro, > >Many thanks for your answer, I think that running the clearTopoGeom in the >trigger function may work, as the idea is do all this inside a before update >trigger function row by row, whenever the original geometry i

Re: [postgis-users] Topology - RemoveUnusedPrimitives workflow

2023-11-07 Thread Alexandre Neto via postgis-users
Hi Sandro, Many thanks for your answer, I think that running the clearTopoGeom in the trigger function may work, as the idea is do all this inside a before update trigger function row by row, whenever the original geometry is changed. Thanks, Alexandre Neto On Tue Nov 7, 2023, 11:33 AM GMT, S

Re: [postgis-users] Topology - RemoveUnusedPrimitives workflow

2023-11-07 Thread Sandro Santilli via postgis-users
On Thu, Nov 02, 2023 at 03:26:22PM +, Alexandre Neto via postgis-users wrote: > UPDATE temp.troco SET > topo = totopogeom(geom, 'master_topology',1) [..] > Now I decided to remove one of the linestrings that splited two polygons. > > And I rerun the updated on the topo columns: > > UPDATE

[postgis-users] Topology - RemoveUnusedPrimitives workflow

2023-11-02 Thread Alexandre Neto via postgis-users
Hi, I am trying to use the RemoveUnusedPrimitives function to clean up my topology and clean unnecessary primitives in the following (not working) way. I have created a topology using SELECT createtopology('master_topology', 3763); To an existing linestring table I have added a topogeometry co