Mercurial > gemma

changeset 5663:a26d2afe0c01

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed access rights shenanigans with geonames import. Getting the file access rights right, so that db server side COPY works is somewhat a PITA, we are using the client side \copy command now.
author Sascha Wilde <wilde@sha-bang.de>
date Wed, 29 Nov 2023 13:22:05 +0100
parents 949f399d0e71
children daa39433bef1
files schema/geonames-import/import-geonames.sql
diffstat 1 files changed, 2 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/geonames-import/import-geonames.sql	Wed Nov 29 12:16:41 2023 +0100
+++ b/schema/geonames-import/import-geonames.sql	Wed Nov 29 13:22:05 2023 +0100
@@ -34,7 +34,8 @@
        modification_date timestamp
 );
 
-COPY geonames_import_tmp FROM :'filename' WITH NULL '';
+\set cpycmd '\\copy geonames_import_tmp FROM ' :'filename' ' WITH NULL \'\';'
+:cpycmd
 
 INSERT INTO waterway.geonames
   SELECT geonameid,