log slow queries and hints

Started by Vasiliy G Tolstovover 16 years ago2 messagesgeneral
Jump to latest
#1Vasiliy G Tolstov
v.tolstov@selfip.ru

Hello. I'm new with postgresql, some times ago i'm turn on log slow
queries, but log file contains not only queries , nor
Oct 28 13:03:44 selfip postgres[18072]: [5-1]
user=dbu_vase_1,db=db_vase_1 WARNING: nonstandard use of \\ in a string
literal at character 90
Oct 28 13:03:44 selfip postgres[18072]: [5-2]
user=dbu_vase_1,db=db_vase_1 HINT: Use the escape string syntax for
backslashes, e.g., E'\\'.

How can i disable this hints, or (i'm use drupal for this database) fix
queries?

--
Vasiliy G Tolstov <v.tolstov@selfip.ru>
Selfip.Ru

#2Richard Huxton
dev@archonet.com
In reply to: Vasiliy G Tolstov (#1)
Re: log slow queries and hints

Vasiliy G Tolstov wrote:

user=dbu_vase_1,db=db_vase_1 HINT: Use the escape string syntax for
backslashes, e.g., E'\\'.

How can i disable this hints, or (i'm use drupal for this database) fix
queries?

See the manual section on configuration, "escape_string_warning".

--
Richard Huxton
Archonet Ltd