Description
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.
"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.