Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-263

PostgreSQL Error: Too many parameters specified for RAISE

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.7.08b
    • Fix Version/s: 1.7.09
    • Component/s: Data
    • Labels:
      None
    • Rank:
      0|i003ef:
    • i2b2 Sponsored Project/s:
      i2b2 Core
    • Affects Database/s:
      PostgreSQL

      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.

        Attachments

          Activity

            People

            • Assignee:
              jmd86 Janice Donahoe
              Reporter:
              jmd86 Janice Donahoe
              Participant/s:
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code