Database errors when using initialize_postgres.sql

postgres.log

CREATE DATABASE
You are now connected to database "dependencycheck" as user "postgres".
CREATE ROLE
psql:/initialize_postgres.sql:7: ERROR:  syntax error at or near ";"
LINE 1: DROP FUNCTION IF EXISTS public.save_property;
                                                    ^
psql:/initialize_postgres.sql:9: ERROR:  syntax error at or near ";"
LINE 1: DROP FUNCTION IF EXISTS public.update_vulnerability;
                                                           ^
psql:/initialize_postgres.sql:11: ERROR:  syntax error at or near ";"
LINE 1: DROP FUNCTION IF EXISTS public.insert_software;
                                                      ^
psql:/initialize_postgres.sql:13: ERROR:  syntax error at or near ";"
LINE 1: DROP FUNCTION IF EXISTS public.merge_ecosystem;
                                                      ^
DROP TABLE
psql:/initialize_postgres.sql:15: NOTICE:  table "software" does not exist, skipping
psql:/initialize_postgres.sql:17: NOTICE:  table "cpeentry" does not exist, skipping
psql:/initialize_postgres.sql:19: NOTICE:  table "reference" does not exist, skipping
DROP TABLE
DROP TABLE
DROP TABLE
psql:/initialize_postgres.sql:21: NOTICE:  table "properties" does not exist, skipping
DROP TABLE
psql:/initialize_postgres.sql:23: NOTICE:  table "cweentry" does not exist, skipping
psql:/initialize_postgres.sql:25: NOTICE:  table "vulnerability" does not exist, skipping
DROP TABLE
psql:/initialize_postgres.sql:27: NOTICE:  table "cpeecosystemcache" does not exist, skipping
DROP TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
INSERT 0 1
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
GRANT
GRANT
psql:/initialize_postgres.sql:165: ERROR:  syntax error at or near "$"
LINE 1: ...N prop varchar(50), IN val varchar(500)) RETURNS void AS $ $
                                                                    ^
psql:/initialize_postgres.sql:180: ERROR:  column "prop" does not exist
LINE 4:     prop,
            ^
psql:/initialize_postgres.sql:182: ERROR:  syntax error at or near "$"
LINE 1: $ $ LANGUAGE sql;
        ^
psql:/initialize_postgres.sql:184: ERROR:  function public.save_property(character varying, character varying) does not exist
psql:/initialize_postgres.sql:205: ERROR:  syntax error at or near "$"
LINE 5: ) RETURNS void AS $ $ BEGIN IF EXISTS(
                          ^
psql:/initialize_postgres.sql:211: ERROR:  syntax error at or near "ELSE"
LINE 1: ELSE
        ^
psql:/initialize_postgres.sql:213: ERROR:  syntax error at or near "IF"
LINE 1: END IF;
            ^
psql:/initialize_postgres.sql:215: ERROR:  syntax error at or near "$"
LINE 1: END $ $ LANGUAGE plpgsql;
            ^
psql:/initialize_postgres.sql:217: ERROR:  function public.merge_ecosystem(character varying, character varying, character varying) does not exist
psql:/initialize_postgres.sql:251: ERROR:  syntax error at or near "$"
LINE 33: ) RETURNS TABLE (vulnerabilityId INT) AS $ $ DECLARE vulnera...
                                                  ^
psql:/initialize_postgres.sql:259: ERROR:  syntax error at or near "SELECT"
LINE 2: SELECT
        ^
psql:/initialize_postgres.sql:265: ERROR:  syntax error at or near "IF"
LINE 1: IF vulnerabilityId > 0 THEN
        ^
psql:/initialize_postgres.sql:270: ERROR:  column "vulnerabilityid" does not exist
LINE 4:     cveid = vulnerabilityId;
                    ^
psql:/initialize_postgres.sql:275: ERROR:  column "vulnerabilityid" does not exist
LINE 4:     cveid = vulnerabilityId;
                    ^
psql:/initialize_postgres.sql:311: ERROR:  column "vulnerabilityid" does not exist
LINE 35:     id = vulnerabilityId;
                  ^
psql:/initialize_postgres.sql:381: ERROR:  syntax error at or near "ELSE"
LINE 1: ELSE
        ^
psql:/initialize_postgres.sql:384: ERROR:  lastval is not yet defined in this session
psql:/initialize_postgres.sql:386: ERROR:  syntax error at or near "IF"
LINE 1: END IF;
            ^
psql:/initialize_postgres.sql:390: ERROR:  syntax error at or near "RETURN"
LINE 1: RETURN QUERY
        ^
psql:/initialize_postgres.sql:392: WARNING:  there is no transaction in progress
psql:/initialize_postgres.sql:394: ERROR:  syntax error at or near "$"
LINE 1: $ $ LANGUAGE plpgsql;
        ^
COMMIT
psql:/initialize_postgres.sql:428: ERROR:  function public.update_vulnerability(character varying, character varying, character varying, numeric, numeric, boolean, boolean, boolean, boolean, boolean, numeric, character varying, character varying, character varying, character varying, character varying, character varying, character varying, numeric, numeric, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, numeric, character varying, character varying) does not exist
psql:/initialize_postgres.sql:449: ERROR:  syntax error at or near "$"
LINE 20: ) RETURNS void AS $ $ DECLARE cpeId INT := 0;
                           ^
psql:/initialize_postgres.sql:451: ERROR:  syntax error at or near "currentEcosystem"
LINE 1: currentEcosystem VARCHAR(255);
        ^
psql:/initialize_postgres.sql:471: ERROR:  syntax error at or near "SELECT"
LINE 2: SELECT
        ^
psql:/initialize_postgres.sql:480: ERROR:  syntax error at or near "IF"
LINE 1: IF cpeId > 0 THEN IF currentEcosystem IS NULL
        ^
psql:/initialize_postgres.sql:482: ERROR:  syntax error at or near "IF"
LINE 1: END IF;
            ^
psql:/initialize_postgres.sql:514: ERROR:  syntax error at or near "ELSE"
LINE 1: ELSE
        ^
psql:/initialize_postgres.sql:517: ERROR:  lastval is not yet defined in this session
psql:/initialize_postgres.sql:519: ERROR:  syntax error at or near "IF"
LINE 1: END IF;
            ^
psql:/initialize_postgres.sql:540: ERROR:  column "p_vulnerabilityid" does not exist
LINE 13:         p_vulnerabilityId,
                 ^
psql:/initialize_postgres.sql:542: WARNING:  there is no transaction in progress
psql:/initialize_postgres.sql:544: ERROR:  syntax error at or near "$"
LINE 1: $ $ LANGUAGE plpgsql;
        ^
COMMIT
psql:/initialize_postgres.sql:565: ERROR:  function public.insert_software(integer, character, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, boolean) does not exist
INSERT 0 1