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

PostgreSQL Error: Too many parameters specified for RAISE

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.08b
    • 1.7.09
    • Data
    • None
    • Rank:
      0|i003ef:
    • i2b2 Core
    • 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

            jmd86 Janice Donahoe
            jmd86 Janice Donahoe
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: