Uploaded image for project: 'ListenBrainz'
  1. ListenBrainz
  2. LB-244

Use newer PostgreSQL syntax for SQL initialization

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • None
    • data store
    • None

      Summary

      Some of the PostgreSQL initialization uses outdated syntax (NOCREATEUSER) and needs to be updated (NOSUPERUSER).

      Background

      Same issue described in MBS-9141.

      Details

      The syntax is explained in the PostgreSQL documentation and the deprecated method is removed in 9.6.

      An excerpt:

      {{CREATEUSER
      NOCREATEUSER
      These clauses are an obsolete, but still accepted, spelling of SUPERUSER and NOSUPERUSER. Note that they are not equivalent to CREATEROLE as one might naively expect!}}

      Action

      Find all references with the old syntax and update them, like create_test_db.sql.

            jflory Justin W. Flory
            jflory Justin W. Flory
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package