In <200910121356.40435.bss@iguanasuicide.net>, Boyd Stephen Smith Jr. wrote: >Anyone? (Only quoted text follows.) > >On Tuesday 06 October 2009 23:01:51 Boyd Stephen Smith Jr. wrote: >> I'm running drupal 6 on top of postgres 8.3 and apache 2 (all from Lenny), >> at the address in my signature. It has recently come to my attention that >> postgres is regularly logging some messages that might be of some concern. >> They come in two styles, one complaining about backslashes: >> --- >> Oct 7 02:02:24 rei postgres[20126]: [3-1] 2009-10-07 02:02:24 UTC >> WARNING: nonstandard use of \\ in a string literal at character 25 >> Oct 7 02:02:24 rei postgres[20126]: [3-2] 2009-10-07 02:02:24 UTC HINT: >> Use the escape string syntax for backslashes, e.g., E'\\'. >> --- >> and another complaining about invalid UTF-8 characters: >> --- >> Oct 7 00:36:31 rei postgres[18120]: [3-1] 2009-10-07 00:36:31 UTC ERROR: >> invalid byte sequence for encoding "UTF8": 0xa0 >> Oct 7 00:36:31 rei postgres[18120]: [3-2] 2009-10-07 00:36:31 UTC HINT: >> This error can also happen if the byte sequence does not match the >> encoding expected by the >> Oct 7 00:36:31 rei postgres[18120]: [3-3] server, which is controlled by >> "client_encoding". >> --- >> >> I think my postgres and drupal configurations are mutually compatible or >> should be. http://drupal.org/node/426008 http://mikkel.hoegh.org/blog/2010/aug/9/tip-using-postgresql-drupal-6/ http://momjian.us/main/blogs/pgblog/2010.html#August_9_2010 Postgres 8+ has an option to handle stings as Drupal 6 expects. Postgres 9+ will have this option on my default. The old Postgres 7- behavior is not standards-compliant and an artifact of Postgres' development. I guess I was just a bit ahead of a solution. There's not even a work-around posted on the 'Net until 1 month after my second post. -- Boyd Stephen Smith Jr. ,= ,-_-. =. bss@iguanasuicide.net ((_/)o o(\_)) ICQ: 514984 YM/AIM: DaTwinkDaddy `-'(. .)`-' http://iguanasuicide.net/ \_/
Attachment:
signature.asc
Description: This is a digitally signed message part.