|
no, i respect your questions, but i can't answer them. because i
don't know in detail what osm2pgsql is doing.
planet_osm_line it postgis
see:
Tabelle »public.planet_osm_line«
Spalte | Typ |
Sortierfolge | NULL erlaubt? | Vorgabewert
---------------------------------+---------------------------+--------------+---------------+-------------
osm_id | bigint
| | |
access | text
| | |
addr:housename | text
| | |
addr:housenumber | text
| | |
addr:interpolation | text
| | |
admin_level | text
| | |
aerialway | text
| | |
aeroway | text
| | |
amenity | text
| | |
area | text
| | |
barrier | text
| | |
bicycle | text
| | |
brand | text
| | |
bridge | text
| | |
boundary | text
| | |
building | text
| | |
construction | text
| | |
covered | text
| | |
culvert | text
| | |
cutting | text
| | |
denomination | text
| | |
disused | text
| | |
embankment | text
| | |
foot | text
| | |
generator:source | text
| | |
harbour | text
| | |
highway | text
| | |
historic | text
| | |
horse | text
| | |
intermittent | text
| | |
junction | text
| | |
landuse | text
| | |
layer | text
| | |
leisure | text
| | |
lock | text
| | |
man_made | text
| | |
military | text
| | |
motorcar | text
| | |
name | text
| | |
natural | text
| | |
office | text
| | |
oneway | text
| | |
operator | text
| | |
place | text
| | |
population | text
| | |
power | text
| | |
power_source | text
| | |
public_transport | text
| | |
railway | text
| | |
ref | text
| | |
religion | text
| | |
route | text
| | |
service | text
| | |
shop | text
| | |
sport | text
| | |
surface | text
| | |
toll | text
| | |
tourism | text
| | |
tower:type | text
| | |
tracktype | text
| | |
tunnel | text
| | |
water | text
| | |
waterway | text
| | |
wetland | text
| | |
width | text
| | |
wood | text
| | |
z_order | integer
| | |
way_area | real
| | |
addr:postcode | text
| | |
de:amtlicher_gemeindeschluessel | text
| | |
de:regionalschluessel | text
| | |
ISO3166-1:alpha3 | text
| | |
maxspeed | text
| | |
maxspeed:forward | text
| | |
maxspeed:backward | text
| | |
name:de | text
| | |
note | text
| | |
postal_code | text
| | |
tags | hstore
| | |
way | geometry(LineString,4326)
| | |
Indexe:
"idx_planet_osm_line_highway" btree (highway)
"planet_osm_line_index" gist (way), Tablespace »planet3_is1«
"planet_osm_line_pkey" btree (osm_id), Tablespace
»planet3_is1«
"planet_osm_line_tags_index" gin (tags), Tablespace
»planet3_is1«
Tablespace: »planet3_ts1«
Am 28.08.2018 um 16:33 schrieb Alvaro
Herrera:
On 2018-Aug-28, wambacher@xxxxxxxxx wrote:
updates are done using a program, that is without my control: osm2pgsql.
this program does everthing which is necessary including locking. and
it't running for years on many, many openstreetmap servers.
because there was a crash before, it must be a data corruption problem,
not programming error.
It's curious that you reply to my email and not respond to a single of
the questions I posed, and instead answered questions I didn't ask.
Perhaps you thought I asked them because I was bored?
What is the definition of the table? It sounds like there's some GIS
datatype -- Right? Are there any triggers or some other fun fact about
this delete? What is the isolation level in effect when the delete
runs?
|
