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: