PostgreSQL nonstandard use of escape in a string literal

From: "Johnson, Trevor" <trevor(dot)johnson(at)tafensw(dot)edu(dot)au>
To: <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL nonstandard use of escape in a string literal
Date: 2009-09-18 04:05:54
Message-ID: E216E88CF27F764FA28DE70BE9C2D84B05E2AC96@WAF4.riverina.det.win
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Using Moodle with PostgreSQL 8.4 and we get warning messages...

2009-09-18 13:48:11 ESTWARNING: nonstandard use of escape in a string
literal at character 209

2009-09-18 13:48:11 ESTHINT: Use the escape string syntax for escapes,
e.g., E'\r\n'.

"standard_conforming_strings" is set to off, if we turn it on it breaks
Moodle.

Are these just warnings or is there something we need to fix?

If so is it okay to turn the warnings with escape_string_warning = off ?

Regards

Trevor

Trevor Johnson
Applications and Database Administrator | Information Management
Services Division | TAFE NSW Riverina Institute
Ph 02 69381351 | Fax 02 69381432 | Mob 0418 600606 | email:
trevor(dot)johnson(at)det(dot)nsw(dot)edu(dot)au <mailto:trevor(dot)johnson(at)det(dot)nsw(dot)edu(dot)au>

**********************************************************************
This message is intended for the addressee named and may contain
privileged information or confidential information or both. If you
are not the intended recipient please delete it and notify the sender.
**********************************************************************

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2009-09-18 04:11:54 Re: PostgreSQL nonstandard use of escape in a string literal
Previous Message Scott Marlowe 2009-09-18 03:35:27 Re: haversine formula with postgreSQL