Июнь 25, 2018, 03:24:45

Автор Тема: Postgresql валит nonstandard use of \\ in a string literal at character  (Прочитано 5305 раз)

lion

  • Administrator
  • Супер пользователь
  • *****
  • Сообщений: 279
  • Карма: +2/-0
    • Просмотр профиля
    • SoftLine
    • Email
Почему-то 8.2 сервер решил что нужно запутать мозги людям и начал заваливать логи постгресса такой гадостью:

MSD WARNING:  nonstandard use of \\ in a string literal at character 109
MSD HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
MSD WARNING:  nonstandard use of \\ in a string literal at character 145
MSD HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
MSD WARNING:  nonstandard use of \\ in a string literal at character 217
MSD HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
MSD WARNING:  nonstandard use of \\ in a string literal at character 145
MSD HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
MSD WARNING:  nonstandard use of \\ in a string literal at character 109
MSD HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
MSD WARNING:  nonstandard use of \\ in a string literal at character 109
MSD HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.

выключил контроль последовательности ESCAPE
в конфигурационном файле: /var/lib/pgsql/
#escape_string_warning = on
поменял на
escape_string_warning = off

Логи стали нормального размера....

damon

  • Новичок
  • *
  • Сообщений: 10
  • Карма: +0/-0
    • Просмотр профиля
    • Email
Re: Postgresql валит nonstandard use of \\ in a string literal at character
« Ответ #1 : Октябрь 10, 2011, 11:34:23 »
как бы еще эту хрень убрать:
LOG:  Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0
STATEMENT:  SELECT c.tableoid, c.oid, c.relname, c.relacl, c.relkind, c.relnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = c.relowner) AS rolname, c.relchecks, c.relhastriggers, c.relhasindex, c.relhasrules, c.relhasoids, c.relfrozenxid, CASE WHEN c.reloftype <> 0 THEN c.reloftype::pg_catalog.regtype ELSE NULL END AS reloftype, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, (SELECT spcname FROM pg_tablespace t WHERE t.oid = c.reltablespace) AS reltablespace, array_to_string(c.reloptions, ', ') AS reloptions, array_to_string(array(SELECT 'toast.' || x FROM unnest(tc.reloptions) x), ', ') AS toast_reloptions FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype = 'a') LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid) WHERE c.relkind in ('r', 'S', 'v', 'c') ORDER BY c.oid
LOG:  Can't find mchar/mvarvarchar types: mchar=0 mvarchar=0
STATEMENT:  SELECT c.tableoid, c.oid, c.relname, c.relacl, c.relkind, c.relnamespace, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = c.relowner) AS rolname, c.relchecks, c.relhastriggers, c.relhasindex, c.relhasrules, c.relhasoids, c.relfrozenxid, CASE WHEN c.reloftype <> 0 THEN c.reloftype::pg_catalog.regtype ELSE NULL END AS reloftype, d.refobjid AS owning_tab, d.refobjsubid AS owning_col, (SELECT spcname FROM pg_tablespace t WHERE t.oid = c.reltablespace) AS reltablespace, array_to_string(c.reloptions, ', ') AS reloptions, array_to_string(array(SELECT 'toast.' || x FROM unnest(tc.reloptions) x), ', ') AS toast_reloptions FROM pg_class c LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid = c.tableoid AND d.objid = c.oid AND d.objsubid = 0 AND d.refclassid = c.tableoid AND d.deptype = 'a') LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid) WHERE c.relkind in ('r', 'S', 'v', 'c') ORDER BY c.oid
CentOS Linux release 6.0 (Final)
2.6.32-131.12.1.el6.x86_64 #1 SMP Mon Sep 26 10:13:43 BST 2011 x86_64 x86_64 x86_64 GNU/Linux
postgresql-9.0.3-3.1C