Skip site navigation (1) Skip section navigation (2)

debug nonstandard use of \\ in a string literal

From: "Ivan Zolotukhin" <ivan(dot)zolotukhin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: debug nonstandard use of \\ in a string literal
Date: 2008-02-28 09:47:45
Message-ID: 751e56400802280147q22bd39aftd234176b34ebc783@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Hello,

From time to time I face with these well-known warnings in the
PostgreSQL log, i.e.

Feb 28 04:21:10 db7 postgres[31142]: [2-1] WARNING:  nonstandard use
of escape in a string literal at character 62
Feb 28 04:21:10 db7 postgres[31142]: [2-2] HINT:  Use the escape
string syntax for escapes, e.g., E'\r\n'.

This is fine, everybody knows about that and our PL/PgSQL developers
try to make use of escape syntax. But sometimes errors occur anyway
(by developers mistakes or something). So the question is: how to
debug these annoying messages when pretty big application causes them?
Is it possible to have a look what exact queries produced them?

--
Regards,
 Ivan

Responses

pgsql-general by date

Next:From: Richard HuxtonDate: 2008-02-28 09:53:26
Subject: Re: on update, how to change the value?
Previous:From: A BDate: 2008-02-28 09:16:09
Subject: on update, how to change the value?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group