Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-22189

moodle produces warnings with postgresql >= 8.3 (ESTWARNING: nonstandard use of \' in a string literal at character)

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 1.9.8
    • Fix Version/s: None
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_19_STABLE

      Description

      Hi,

      I just upgrade to postgres 8.3. There are lots of warnings like:
      "ESTWARNING: nonstandard use of \' in a string literal at character"

      I guess that was discussed here before:
      http://moodle.org/mod/forum/discuss.php?d=132739

      Trevor Johnson wrote:
      "For Moodle 1.9.5 on PostgreSQL 8.4 you need to set "standard_conforming_strings" to off, which is the default for PostgreSQL 8.4.
      And then to turn the event log warnings off, set escape_string_warning to off, the default is on."

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: