Three of the create stored procedures scripts for PostgreSQL will return the following error when they are run:

      "Too many parameters specified for RAISE"

The three scripts that have the problem are:

      "create_temp_patient_table"
      "create_temp_pid_table"
      "create_temp_eid_table"



LINE CAUSING THE ERROR:
The following line can be found in all three scripts and is causing the errors:

        RAISE NOTICE '%%%', SQLSTATE, ' - ' , SQLERRM;


REASON:
In PostgreSQL ‘RAISE NOTICE’ can only have two parameters defined.