-
Notifications
You must be signed in to change notification settings - Fork 0
/
procedura cable_COAX_KKE_data_update_add_house_id.sql
318 lines (288 loc) · 24.1 KB
/
procedura cable_COAX_KKE_data_update_add_house_id.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
CREATE OR REPLACE FUNCTION public.cable_channels_coax_data_update() RETURNS trigger AS $cable_channels_coax_data_update$
--!!!!!! использую для замены оригинальной функции cable_channels_coax_data_update !!!!!!!!!!!!! --
DECLARE
city name :=TG_TABLE_SCHEMA;
geom_start_point_state boolean;
geom_end_point_state boolean;
geom_start_point_state_house boolean;
geom_end_point_state_house boolean;
BEGIN
IF TG_OP = 'INSERT' THEN
--оригинальная функция cable_channels_coax_data_update ()
-----ниже моя вставка для упрощённого подхода к рисованию(можно вносить тип кабеля напр QR-540 и/или длина )
-- тут есть некий дисонанс: если мы пытаемя обновить поля в слое "для рисования" система не даёт их перезаписать и в слоях кабели_ВКП_для_рисования и в кабели_ВКП будут разные данные - это будет вносить сумятицу: в связи с чем есть идея: затирать данные в таблице кабели_ВКП_для_рисования (добавил ниже)
--все таблицы типа _cable_channel_coax_geom поле cable_description (марка кабеля- по умолчанию нет этого поля в таблицах _cable_channel_coax_geom) и заменить в скриптах ниже cable_description на cable_description !
-- нужно ещё будет подумать об исключениях RAISE EXCEPTION https://stackoverflow.com/questions/42890652/update-a-column-in-a-function-using-plpgsql
-- добавить во все таблицы _cable_channels_coax в поле cable_type значение по умолчанию 'optic' !!!
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cable_short_type_description = '||city||'_cable_channel_coax_geom.cable_short_type_description
FROM '||city||'.'||city||'_cable_channel_coax_geom
WHERE '||city||'_cable_channels_coax.table_id = '||city||'_cable_channel_coax_geom.table_id and '||city||'_cable_channels_coax.cable_short_type_description is NULL;
UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cable_description = '||city||'_cable_channel_coax_geom.cable_description
FROM '||city||'.'||city||'_cable_channel_coax_geom
WHERE '||city||'_cable_channels_coax.table_id = '||city||'_cable_channel_coax_geom.table_id and '||city||'_cable_channels_coax.cable_description is NULL;
UPDATE '||city||'.'||city||'_cable_channels_coax
SET
total_cable_length='||city||'_cable_channel_coax_geom.total_cable_length
FROM '||city||'.'||city||'_cable_channel_coax_geom
WHERE '||city||'_cable_channels_coax.table_id = '||city||'_cable_channel_coax_geom.table_id and '||city||'_cable_channels_coax.total_cable_length is NULL;
UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cable_type=DEFAULT
WHERE '||city||'_cable_channels_coax.cable_type is NULL and '||city||'_cable_channels_coax.cable_short_type_description is NOT NULL;' USING NEW;
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channel_coax_geom
SET
cable_short_type_description = NULL,
cable_description = NULL,
total_cable_length = NULL
WHERE '||city||'_cable_channel_coax_geom.cable_short_type_description is NOT NULL OR '||city||'_cable_channel_coax_geom.cable_description is NOT NULL OR '||city||'_cable_channel_coax_geom.total_cable_length is NOT NULL' USING NEW; /* затираем данные после сохранения вроде работает норм*/
----------------
---------ниже вставка привязки домов к концам кабеля (подъезды обновляем отдельно)----------------
EXECUTE 'SELECT CASE WHEN count(*) > 0 THEN TRUE ELSE FALSE END FROM '||city||'.'||city||'_buildings WHERE ST_Distance(ST_StartPoint($1.geom) ,'||city||'_buildings.building_geom) <= 4.1 ' INTO geom_start_point_state_house USING NEW;
EXECUTE 'SELECT CASE WHEN count(*) > 0 THEN TRUE ELSE FALSE END FROM '||city||'.'||city||'_buildings WHERE ST_Distance(ST_EndPoint($1.geom) ,'||city||'_buildings.building_geom) <= 4.1 ' INTO geom_end_point_state_house USING NEW;
IF geom_start_point_state_house = TRUE THEN
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_start_house_id = '||city||'_buildings.cubic_house_id,
cubic_start_street = '||city||'_buildings.cubic_street,
cubic_start_house_num = '||city||'_buildings.cubic_house
FROM '||city||'.'||city||'_buildings
WHERE (ST_Distance(ST_StartPoint($1.geom),'||city||'_buildings.building_geom) <= 4.1 AND '||city||'_cable_channels_coax.table_id = $1.table_id) ' USING NEW;
END IF;
IF geom_end_point_state_house = TRUE THEN
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_end_house_id = '||city||'_buildings.cubic_house_id,
cubic_end_street = '||city||'_buildings.cubic_street,
cubic_end_house_num = '||city||'_buildings.cubic_house
FROM '||city||'.'||city||'_buildings
WHERE (ST_Distance(ST_EndPoint($1.geom),'||city||'_buildings.building_geom ) <= 4.1 AND '||city||'_cable_channels_coax.table_id = $1.table_id) ' USING NEW , city;
END IF;
--------------------------ниже добавляем обновляем подъезды к концам кабеля --------
EXECUTE 'SELECT CASE WHEN count(*) > 0 THEN TRUE ELSE FALSE END FROM '||city||'.'||city||'_entrances WHERE ST_Distance(ST_StartPoint($1.geom) ,'||city||'_entrances.geom) <= 6.1 ' INTO geom_start_point_state_house USING NEW;
EXECUTE 'SELECT CASE WHEN count(*) > 0 THEN TRUE ELSE FALSE END FROM '||city||'.'||city||'_entrances WHERE ST_Distance(ST_EndPoint($1.geom) ,'||city||'_entrances.geom) <= 6.1 ' INTO geom_end_point_state_house USING NEW;
IF geom_start_point_state_house = TRUE THEN
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_start_house_entrance_num = '||city||'_entrances.cubic_entrance_number
FROM '||city||'.'||city||'_entrances
WHERE (ST_Distance(ST_StartPoint($1.geom),'||city||'_entrances.geom) <= 6.1 AND '||city||'_cable_channels_coax.table_id = $1.table_id) ' USING NEW;
END IF;
IF geom_end_point_state_house = TRUE THEN
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_end_house_entrance_num = '||city||'_entrances.cubic_entrance_number
FROM '||city||'.'||city||'_entrances
WHERE (ST_Distance(ST_EndPoint($1.geom),'||city||'_entrances.geom ) <= 6.1 AND '||city||'_cable_channels_coax.table_id = $1.table_id) ' USING NEW , city;
END IF;
-------------------------
EXECUTE 'SELECT CASE WHEN count(*) > 0 THEN TRUE ELSE FALSE END FROM '||city||'.'||city||'_ctv_topology WHERE ST_Distance(ST_StartPoint($1.geom) ,'||city||'_ctv_topology.equipment_geom) <= 2.8 AND '||city||'_ctv_topology.cubic_name IN (''Домовой узел'', ''Магистральный узел'', ''Ответвитель магистральный'',''Порт ОК'') ' INTO geom_start_point_state USING NEW;
EXECUTE 'SELECT CASE WHEN count(*) > 0 THEN TRUE ELSE FALSE END FROM '||city||'.'||city||'_ctv_topology WHERE ST_Distance(ST_EndPoint($1.geom) ,'||city||'_ctv_topology.equipment_geom) <= 2.8 AND '||city||'_ctv_topology.cubic_name IN (''Домовой узел'', ''Магистральный узел'', ''Ответвитель магистральный'',''Порт ОК'') ' INTO geom_end_point_state USING NEW;
IF geom_start_point_state = TRUE THEN
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_code_start = '||city||'_ctv_topology.cubic_code,
cubic_name_start = '||city||'_ctv_topology.cubic_name,
cubic_coment_start = '||city||'_ctv_topology.cubic_coment,
geom_start_point = '||city||'_ctv_topology.equipment_geom,
geom_cable = ST_SetPoint($1.geom,0,'||city||'_ctv_topology.equipment_geom)
FROM '||city||'.'||city||'_ctv_topology
WHERE (ST_Equals('||city||'_ctv_topology.equipment_geom , ST_StartPoint($1.geom)) OR (ST_Distance(ST_StartPoint($1.geom),'||city||'_ctv_topology.equipment_geom) <= 2.8)) AND '||city||'_cable_channels_coax.table_id = $1.table_id AND '||city||'_ctv_topology.cubic_name IN (''Домовой узел'', ''Магистральный узел'', ''Ответвитель магистральный'',''Порт ОК'') ' USING NEW;
ELSE
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_code_start = NULL,
cubic_name_start = NULL,
cubic_coment_start = NULL,
geom_start_point = ST_StartPoint($1.geom),
geom_cable = $1.geom
WHERE '||city||'_cable_channels_coax.table_id = $1.table_id' USING NEW;
END IF;
IF geom_end_point_state = TRUE THEN
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_code_end = '||city||'_ctv_topology.cubic_code,
cubic_name_end = '||city||'_ctv_topology.cubic_name,
cubic_coment_end = '||city||'_ctv_topology.cubic_coment,
geom_end_point = '||city||'_ctv_topology.equipment_geom,
geom_cable = ST_SetPoint($1.geom,ST_NPoints($1.geom)-1,'||city||'_ctv_topology.equipment_geom)
FROM '||city||'.'||city||'_ctv_topology
WHERE (ST_Equals('||city||'_ctv_topology.equipment_geom ,ST_EndPoint($1.geom)) OR (ST_Distance(ST_EndPoint($1.geom) ,'||city||'_ctv_topology.equipment_geom) <= 2.8)) AND '||city||'_cable_channels_coax.table_id = $1.table_id AND '||city||'_ctv_topology.cubic_name IN (''Домовой узел'', ''Магистральный узел'', ''Ответвитель магистральный'',''Порт ОК'') ' USING NEW , city;
ELSE
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_code_end = NULL,
cubic_name_end = NULL,
cubic_coment_end = NULL,
geom_end_point = ST_EndPoint($1.geom),
geom_cable = $1.geom
WHERE '||city||'_cable_channels_coax.table_id = $1.table_id' USING NEW;
END IF;
RETURN NEW;
ELSIF TG_OP = 'UPDATE' THEN
-----ниже вставка --это новый упрощённый подход к рисованию кабелей
-- тут есть некий дисонанс: если мы пытаемя обновить поля в слое "для рисования" система не даёт их перезаписать и в слоях кабели_ВКП_для_рисования и в кабели_ВКП будут разные данные - это будет вносить сумятицу: в связи с чем есть идея: затирать данные в таблице кабели_ВКП_для_рисования (скрипт добавил ниже)
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cable_short_type_description = '||city||'_cable_channel_coax_geom.cable_short_type_description
FROM '||city||'.'||city||'_cable_channel_coax_geom
WHERE '||city||'_cable_channels_coax.table_id = '||city||'_cable_channel_coax_geom.table_id and '||city||'_cable_channels_coax.cable_short_type_description is NULL;
UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cable_description = '||city||'_cable_channel_coax_geom.cable_description
FROM '||city||'.'||city||'_cable_channel_coax_geom
WHERE '||city||'_cable_channels_coax.table_id = '||city||'_cable_channel_coax_geom.table_id and '||city||'_cable_channels_coax.cable_description is NULL;
UPDATE '||city||'.'||city||'_cable_channels_coax
SET
total_cable_length='||city||'_cable_channel_coax_geom.total_cable_length
FROM '||city||'.'||city||'_cable_channel_coax_geom
WHERE '||city||'_cable_channels_coax.table_id = '||city||'_cable_channel_coax_geom.table_id and '||city||'_cable_channels_coax.total_cable_length is NULL;
UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cable_type=DEFAULT
WHERE '||city||'_cable_channels_coax.cable_type is NULL and '||city||'_cable_channels_coax.cable_short_type_description is NOT NULL;' USING NEW;
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channel_coax_geom
SET
cable_short_type_description = NULL,
cable_description = NULL,
total_cable_length = NULL
WHERE '||city||'_cable_channel_coax_geom.cable_short_type_description is NOT NULL OR '||city||'_cable_channel_coax_geom.cable_description is NOT NULL OR '||city||'_cable_channel_coax_geom.total_cable_length is NOT NULL' USING NEW; /* затераем данные в cable_air_cable_geom после сохранения вроде работает норм*/
------------------------------
---------ниже вставка привязки домов к концам кабеля (подъезды обновляем отдельно)---------------
EXECUTE 'SELECT CASE WHEN count(*) > 0 THEN TRUE ELSE FALSE END FROM '||city||'.'||city||'_buildings WHERE ST_Distance(ST_StartPoint($1.geom) ,'||city||'_buildings.building_geom) <= 4.1 ' INTO geom_start_point_state_house USING NEW;
EXECUTE 'SELECT CASE WHEN count(*) > 0 THEN TRUE ELSE FALSE END FROM '||city||'.'||city||'_buildings WHERE ST_Distance(ST_EndPoint($1.geom) ,'||city||'_buildings.building_geom) <= 4.1 ' INTO geom_end_point_state_house USING NEW;
IF geom_start_point_state_house = TRUE THEN
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_start_house_id = '||city||'_buildings.cubic_house_id,
cubic_start_street = '||city||'_buildings.cubic_street,
cubic_start_house_num = '||city||'_buildings.cubic_house
FROM '||city||'.'||city||'_buildings
WHERE (ST_Distance(ST_StartPoint($1.geom),'||city||'_buildings.building_geom) <= 4.1 AND '||city||'_cable_channels_coax.table_id = $1.table_id) ' USING NEW;
ELSE
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_start_house_id = NULL,
cubic_start_street = NULL,
cubic_start_house_num = NULL
WHERE '||city||'_cable_channels_coax.table_id = $1.table_id' USING NEW;
END IF;
IF geom_end_point_state_house = TRUE THEN
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_end_house_id = '||city||'_buildings.cubic_house_id,
cubic_end_street = '||city||'_buildings.cubic_street,
cubic_end_house_num = '||city||'_buildings.cubic_house
FROM '||city||'.'||city||'_buildings
WHERE (ST_Distance(ST_EndPoint($1.geom),'||city||'_buildings.building_geom ) <= 4.1 AND '||city||'_cable_channels_coax.table_id = $1.table_id) ' USING NEW , city;
ELSE
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_end_house_id = NULL,
cubic_end_street = NULL,
cubic_end_house_num = NULL
WHERE '||city||'_cable_channels_coax.table_id = $1.table_id' USING NEW;
END IF;
--------добавляем обновление полей подъездов к концам кабеля -------
EXECUTE 'SELECT CASE WHEN count(*) > 0 THEN TRUE ELSE FALSE END FROM '||city||'.'||city||'_entrances WHERE ST_Distance(ST_StartPoint($1.geom) ,'||city||'_entrances.geom) <= 6.1 ' INTO geom_start_point_state_house USING NEW;
EXECUTE 'SELECT CASE WHEN count(*) > 0 THEN TRUE ELSE FALSE END FROM '||city||'.'||city||'_entrances WHERE ST_Distance(ST_EndPoint($1.geom) ,'||city||'_entrances.geom) <= 6.1 ' INTO geom_end_point_state_house USING NEW;
IF geom_start_point_state_house = TRUE THEN
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_start_house_entrance_num = '||city||'_entrances.cubic_entrance_number
FROM '||city||'.'||city||'_entrances
WHERE (ST_Distance(ST_StartPoint($1.geom),'||city||'_entrances.geom) <= 6.1 AND '||city||'_cable_channels_coax.table_id = $1.table_id) ' USING NEW;
ELSE
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_start_house_entrance_num = NULL
WHERE ('||city||'_cable_channels_coax.table_id = $1.table_id) ' USING NEW;
END IF;
IF geom_end_point_state_house = TRUE THEN
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_end_house_entrance_num = '||city||'_entrances.cubic_entrance_number
FROM '||city||'.'||city||'_entrances
WHERE (ST_Distance(ST_EndPoint($1.geom),'||city||'_entrances.geom ) <= 6.1 AND '||city||'_cable_channels_coax.table_id = $1.table_id) ' USING NEW , city;
ELSE
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_end_house_entrance_num = NULL
WHERE ('||city||'_cable_channels_coax.table_id = $1.table_id) ' USING NEW;
END IF;
-------------------------------------------------------------------------
EXECUTE 'SELECT CASE WHEN count(*) > 0 THEN TRUE ELSE FALSE END FROM '||city||'.'||city||'_ctv_topology WHERE ST_Distance(ST_StartPoint($1.geom) ,'||city||'_ctv_topology.equipment_geom) <= 2.8 AND '||city||'_ctv_topology.cubic_name IN (''Домовой узел'', ''Магистральный узел'', ''Ответвитель магистральный'',''Порт ОК'')' INTO geom_start_point_state USING NEW;
EXECUTE 'SELECT CASE WHEN count(*) > 0 THEN TRUE ELSE FALSE END FROM '||city||'.'||city||'_ctv_topology WHERE ST_Distance(ST_EndPoint($1.geom) ,'||city||'_ctv_topology.equipment_geom) <= 2.8 AND '||city||'_ctv_topology.cubic_name IN (''Домовой узел'', ''Магистральный узел'', ''Ответвитель магистральный'',''Порт ОК'')' INTO geom_end_point_state USING NEW;
IF geom_start_point_state = TRUE THEN
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_code_start = '||city||'_ctv_topology.cubic_code,
cubic_name_start = '||city||'_ctv_topology.cubic_name,
cubic_coment_start = '||city||'_ctv_topology.cubic_coment,
geom_start_point = '||city||'_ctv_topology.equipment_geom,
geom_cable = ST_SetPoint($1.geom,0,'||city||'_ctv_topology.equipment_geom)
FROM '||city||'.'||city||'_ctv_topology
WHERE (ST_Equals('||city||'_ctv_topology.equipment_geom , ST_StartPoint($1.geom)) OR (ST_Distance(ST_StartPoint($1.geom),'||city||'_ctv_topology.equipment_geom) <= 2.8)) AND '||city||'_cable_channels_coax.table_id = $1.table_id AND '||city||'_ctv_topology.cubic_name IN (''Домовой узел'', ''Магистральный узел'', ''Ответвитель магистральный'',''Порт ОК'') ' USING NEW;
ELSE
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_code_start = NULL,
cubic_name_start = NULL,
cubic_coment_start = NULL,
geom_start_point = ST_StartPoint($1.geom),
geom_cable = $1.geom
WHERE '||city||'_cable_channels_coax.table_id = $1.table_id' USING NEW;
END IF;
IF geom_end_point_state = TRUE THEN
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_code_end = '||city||'_ctv_topology.cubic_code,
cubic_name_end = '||city||'_ctv_topology.cubic_name,
cubic_coment_end = '||city||'_ctv_topology.cubic_coment,
geom_end_point = '||city||'_ctv_topology.equipment_geom,
geom_cable = ST_SetPoint($1.geom,ST_NPoints($1.geom)-1,'||city||'_ctv_topology.equipment_geom)
FROM '||city||'.'||city||'_ctv_topology
WHERE (ST_Equals('||city||'_ctv_topology.equipment_geom ,ST_EndPoint($1.geom)) OR (ST_Distance(ST_EndPoint($1.geom) ,'||city||'_ctv_topology.equipment_geom) <= 2.8)) AND '||city||'_cable_channels_coax.table_id = $1.table_id AND '||city||'_ctv_topology.cubic_name IN (''Домовой узел'', ''Магистральный узел'', ''Ответвитель магистральный'',''Порт ОК'') ' USING NEW , city;
ELSE
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
cubic_code_end = NULL,
cubic_name_end = NULL,
cubic_coment_end = NULL,
geom_end_point = ST_EndPoint($1.geom),
geom_cable = $1.geom
WHERE '||city||'_cable_channels_coax.table_id = $1.table_id' USING NEW;
END IF;
RETURN NEW;
-------------------------------
ELSIF TG_OP = 'DELETE' THEN
EXECUTE 'UPDATE '||city||'.'||city||'_cable_channels_coax
SET
geom_cable =NULL,
geom_end_point = NULL,
geom_start_point = NULL,
cubic_code_start = NULL,
cubic_name_start = NULL,
cubic_coment_start = NULL,
cubic_code_end = NULL,
cubic_name_end = NULL,
cubic_coment_end = NULL,
cubic_end_house_id = NULL,
cubic_start_house_id = NULL,
cubic_start_street = NULL,
cubic_start_house_num = NULL,
cubic_end_street = NULL,
cubic_end_house_num = NULL
WHERE '||city||'_cable_channels_coax.table_id = $1.table_id' USING OLD;
RETURN OLD; -- стоит подтирать и адрес и геометрию после удаления кабелей
END IF;
END;
--------------
$cable_channels_coax_data_update$ LANGUAGE plpgsql;
/*CREATE TRIGGER cable_KKE_house_id AFTER INSERT OR UPDATE OR DELETE ON fastiv.fastiv_cable_channel_coax_geom
FOR EACH ROW EXECUTE PROCEDURE cable_KKE_house_id(); -- если сделать тригер before то нихрена не работает*/
--[city]_cable_channel_coax_geom (0шт) --- лажа какая-то лишняя буква s - нужно поудалаять со всех таблиц и к ним даже процедуры привязаны
--ERROR: column fastiv_cable_channel_coax_geom.cable_description does not exist