[OSM-dev] OpenStreetMap Carto release v5.9.0

[Michael Reichert]

Hi Lynn,

Am 21.10.24 um 16:02 schrieb Lynn W. Deffenbaugh (Mr):
> Thank you Michael,
> 
> I just did that, but renderd failed on the restart with the following in 
> syslog:
> 
>> Oct 21 15:58:53 bee-osm renderd[303293]: An error occurred while 
>> loading the map layer 'ajt': Postgis Plugin: ERROR:  function 
>> carto_path_type(text, text) does not exi     st#012LINE 15: ... 
>> 'highway_' || (CASE WHEN highway = 'path' THEN carto_path...#012 
>> ^#012HINT:  No funct     ion matches the given name and argument 
>> types. You might need to add explicit type casts.#012in executeQuery 
>> Full sql was: 'SELECT * FROM (SELECT#012 way,#012    (C     ASE WHEN 
>> feature IN ('highway_motorway_link', 'highway_trunk_link', 
>> 'highway_primary_link', 'highway_secondary_link', 
>> 'highway_tertiary_link') THEN substr(feature, 0, length(feature)-4) 
>> ELSE feature END) <snip>
> 
> This is a very old import that has been applying updates for 2 years 
> now.   Maybe there's a script I need to re-run to get the Postgis Plugin 
> updated to include the (apparently new) carto_path)_type function?

The function carto_path_type is defined in functions.sql [1]. You have 
to rerun this file against your database using

psql -d gis -f functions.sql

Depending on the owner of your database "gis", you might run this as 
that user using the -U option (see manfile for details). If you use peer 
authentication, you can run this at that user using "sudo -u USERNAME ...".

Best regards

Michael


[1] 
https://github.com/gravitystorm/openstreetmap-carto/blob/v5.9.0/functions.sql#L28


-- 
Michael Reichert      www.geofabrik.de
Geofabrik GmbH        Handelsregister: HRB Mannheim 703657
Amalienstr. 44        Geschaeftsfuehrung: C. Karch, F. Ramm
76133 Karlsruhe       Tel: 0721-1803560-3
reichert at geofabrik.de Fax: 0721-1803560-9