Warning regarding use of \\ in queries
Status: Beta
Brought to you by:
angusgb
System using PostgreSQL 8.2 and Perl DBD Pg module 1.43. When launching the automatic loader, I get this warning:
Loading day '2006-12-04' in the warehouse
Found 49164 sessions in day 2006-12-04
WARNING: nonstandard use of \\ in a string literal
LINE 17: AND c.relname LIKE 'error\\_facts\\_2006\\_12'
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal
LINE 17: AND c.relname LIKE 'sessions\\_2006'
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
I could not find anything in the script, so I assume it is something related to the underlying module. Please verify.