openmaptiles/layers
Patrik Sylve f70ae783b2
Set columns to null instead of dropping to avoid pg_deadlock during updates (#1710)
This PR addresses a pg_deadlock error that would cause an update to fail if a `select getmvt` was queried during update. The deadlock occurred due to an ALTER TABLE DROP COLUMN operation on temporary columns  ( `new_source_ids` and `old_source_ids`) in some linestring tables.

**Changes:**
*  instead of adding/dropping the columns during update, they are now updated and set to NULL. 
* Added new indexes on the source_ids columns  to speed up the UPDATE. 
* Will refresh `osm_park_polygon_dissolve_z4` concurrently in `park_polygon.refresh()` to avoid blocking. 

Co-authored-by: Patrik Sylve <patrik.sylve@t-kartor.com>
2025-02-28 13:27:52 +01:00
..
aerodrome_label Use pg_trigger_depth to avoid re-trigger in update (#1708) 2025-02-18 11:18:04 +01:00
aeroway improve `class=path` styling (#1450) 2023-01-06 10:08:03 +01:00
boundary Removed update trigger on osm_boundary_polygon (#1697) 2024-12-17 07:44:50 +01:00
building OSM OpenMapTiles style (#1420) 2022-10-06 16:09:21 +02:00
housenumber Use pg_trigger_depth to avoid re-trigger in update (#1708) 2025-02-18 11:18:04 +01:00
landcover Add landuse=flowerbed to landcover (#1661) 2024-08-01 12:50:18 +02:00
landuse OSM OpenMapTiles style (#1420) 2022-10-06 16:09:21 +02:00
mountain_peak Use pg_trigger_depth to avoid re-trigger in update (#1708) 2025-02-18 11:18:04 +01:00
park Set columns to null instead of dropping to avoid pg_deadlock during updates (#1710) 2025-02-28 13:27:52 +01:00
place Use pg_trigger_depth to avoid re-trigger in update (#1708) 2025-02-18 11:18:04 +01:00
poi Use pg_trigger_depth to avoid re-trigger in update (#1708) 2025-02-18 11:18:04 +01:00
transportation Set columns to null instead of dropping to avoid pg_deadlock during updates (#1710) 2025-02-28 13:27:52 +01:00
transportation_name Set columns to null instead of dropping to avoid pg_deadlock during updates (#1710) 2025-02-28 13:27:52 +01:00
water Salt pond with class `pond` (#1645) 2024-03-21 15:58:58 +01:00
water_name Use pg_trigger_depth to avoid re-trigger in update (#1708) 2025-02-18 11:18:04 +01:00
waterway Set columns to null instead of dropping to avoid pg_deadlock during updates (#1710) 2025-02-28 13:27:52 +01:00