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: