Uploaded image for project: 'iplike'
  1. iplike
  2. IPL-33

create function updated in PostgreSQL 11.

    XMLWordPrintable

    Details

    • Type: Enhancement
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.1
    • Fix Version/s: 2.1.2
    • Component/s: None
    • Labels:
      None

      Description

      Starting with PostgreSQL 11, the WITH(attribute) was removed from CREATE FUNCTION. If you try to install iplike into PostgreSQL 11, you get an error:

      $ /usr/local/sbin/install_iplike.sh
      ERROR:  syntax error at or near "WITH"
      LINE 1: .../usr/local/lib/postgresql/iplike.so' LANGUAGE 'c' WITH(isstr...
                                                                   ^
      

      Documentation from PostgreSQL 9.4, 9.5, 9.6 and 10 indicate they support WITH(isStrict).

      WITH(isStrict) is equivalent to STRICT or RETURNS NULL ON NULL INPUT.

      Documentation from PostgreSQL 9.4, 9.5, 9.6, 10 and 11 all indicate they support STRICT or RETURNS NULL ON NULL INPUT.

        Attachments

          Activity

            People

            • Assignee:
              ranger Benjamin Reed
              Reporter:
              ronald.roskens@biworldwide.com Ron Roskens
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: