From afabbeb546b94bfcdc1b5fbba37c04b5e07b54ed Mon Sep 17 00:00:00 2001
From: Sarah Hoffmann <lonvia@denofr.de>
Date: Fri, 26 Feb 2021 18:23:24 +0100
Subject: [PATCH] older versions of Postgresql need explicit return type

---
 test/python/test_tools_database_import.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/test/python/test_tools_database_import.py b/test/python/test_tools_database_import.py
index f9760fc0..45324834 100644
--- a/test/python/test_tools_database_import.py
+++ b/test/python/test_tools_database_import.py
@@ -189,7 +189,7 @@ def test_load_data(dsn, src_dir, place_row, placex_table, osmline_table, word_ta
                    temp_db_cursor, threads):
     for func in ('make_keywords', 'getorcreate_housenumber_id', 'make_standard_name'):
         temp_db_cursor.execute("""CREATE FUNCTION {} (src TEXT)
-                                  RETURNS TEXT AS $$ SELECT 'a' $$ LANGUAGE SQL
+                                  RETURNS TEXT AS $$ SELECT 'a'::TEXT $$ LANGUAGE SQL
                                """.format(func))
     for oid in range(100, 130):
         place_row(osm_id=oid)
-- 
2.39.5