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
reich...@geofabrik.de Fax: 0721-1803560-9
_______________________________________________
dev mailing list
dev@openstreetmap.org
https://lists.openstreetmap.org/listinfo/dev
