From 2643753a92fb1873da17f5afd4d76b151fc9304f Mon Sep 17 00:00:00 2001 From: glyn Date: Fri, 23 May 2014 12:29:39 +0100 Subject: [PATCH] Fix a couple of typo's in paf_postgresql_import_postgis.plpgsql --- paf_postgresql_import_postgis.plpgsql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/paf_postgresql_import_postgis.plpgsql b/paf_postgresql_import_postgis.plpgsql index 058c45f..5a16920 100644 --- a/paf_postgresql_import_postgis.plpgsql +++ b/paf_postgresql_import_postgis.plpgsql @@ -267,7 +267,7 @@ BEGIN -- 7) Postzon with latlon generated using postgis TRUNCATE TABLE data_stage; - RAISE NOTICE '%: Begin staging postzone', clock_timestamp(); + RAISE NOTICE '%: Begin staging postzon', clock_timestamp(); v_sql := 'COPY data_stage FROM ' || quote_literal(v_data_postzon || 'pzone100.c01'); EXECUTE v_sql; @@ -946,7 +946,7 @@ BEGIN EXECUTE v_sql; DELETE FROM data_stage WHERE data like '%WCHANGES' || in_edition || '%' OR data like v_main_footer; - RAISE NOTICE '%: Done staging WChanges2 file',clock_timestamp(); + RAISE NOTICE '%: Done staging WChanges file',clock_timestamp(); RAISE NOTICE '%: Preparing to update welsh mainfile', clock_timestamp(); @@ -1063,7 +1063,7 @@ BEGIN -- It would appear postzon is supplied as a full refresh rather than an update file TRUNCATE TABLE data_stage; - RAISE NOTICE '%: Begin staging postzone', clock_timestamp(); + RAISE NOTICE '%: Begin staging postzon', clock_timestamp(); v_sql := 'COPY data_stage FROM ' || quote_literal(v_data_postzon || 'pzone100.c01'); EXECUTE v_sql; @@ -1275,4 +1275,4 @@ LEFT OUTER JOIN public.pc_paf_organisations o USING (organisation_key, postcode_ LEFT OUTER JOIN public.pc_paf_organisations lo ON mw.address_key = lo.organisation_key AND mw.postcode_type = lo.postcode_type LEFT OUTER JOIN public.pc_paf_postzon_100m p USING (outward_code, inward_code) LEFT OUTER JOIN public.pc_paf_county_alias a ON a.postcode = (rpad(mw.outward_code,4) || mw.inward_code) -LEFT OUTER JOIN public.pc_paf_counties apc ON apc.county_key = a.former_postal_county; \ No newline at end of file +LEFT OUTER JOIN public.pc_paf_counties apc ON apc.county_key = a.former_postal_county; -- 2.39.5