linz/linz_bde_uploader — Issue #2: old logging methods still in use
Author: rcoup
Created: 2011-10-20 05:52:23+00:00
State: open

$ ack -i bde_writeupload
sql/bde_functions.sql
970: PERFORM bde_control.bde_WriteUploadLog( p_upload_id,'W',
976: PERFORM bde_control.bde_WriteUploadLog( p_upload_id, 'E',

sql/version_bde_tables.sql
45: PERFORM bde_control.bde_WriteUploadLog(1,'2',v_msg);

Specifically, when running `version_bde_tables.sql` after a clean level0 load:

$ sudo -u lds_bde psql bde_db < /usr/share/linz-bde-uploader/sql/version_bde_tables.sql
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "_changeset_revision_pkey" for table "_changeset_revision"
CONTEXT: SQL statement "CREATE TEMP TABLE _changeset_revision(
revision INTEGER NOT NULL PRIMARY KEY
)"
PL/pgSQL function "ver_create_revision" line 12 at SQL statement
SQL statement "SELECT table_version.ver_create_revision('Initial revisioning for BDE/LDS tables')"
PL/pgSQL function "inline_code_block" line 10 at PERFORM
ERROR: function bde_control.bde_writeuploadlog(integer, unknown, text) does not exist
LINE 1: SELECT bde_control.bde_WriteUploadLog(1,'2',v_msg)
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: SELECT bde_control.bde_WriteUploadLog(1,'2',v_msg)
CONTEXT: PL/pgSQL function "inline_code_block" line 27 at PERFORM