[syslog-ng] 3.3.0alpha2(git) escape \ with postgresql 9.0.4

[Balazs Scheidler]

On Thu, 2011-05-05 at 16:49 +0200, Hendrik Visage wrote:
> Hi there
> 
> (1) Thanks for the default value in the afsql ;)
> 
> (2)warning seen:
> 
> Running SQL query; query='INSERT INTO SystemEvents (ID, ReceivedAt,
> DeviceReportedTime, Facility, Priority, FromHost, Message, InfoUnitID,
> SysLogTag, CustomerID, NTSeverity, Importance, EventSource, EventUser,
> EventCategory, EventID, EventBinaryData, MaxAvailable, CurrUsage,
> MinUsage, MaxUsage, EventLogType, GenericFileName, SystemID) VALUES
> (DEFAULT, \'2011-05-05T16:45:58+02:00\',
> \'2011-05-05T16:45:58+02:00\', \'5\', \'3\', \'pint02\', \' 5 16:27:23
> pint02 syslog-ng[1788]: I/O error occurred while writing;
> fd=\'\'23\'\', error=\'\'Can\\\'\'t assign requested address
> (227)\'\'\', \'1\', \'May \', NULL, NULL, NULL, NULL, NULL, NULL,
> NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)'
> WARNING:  nonstandard use of \\ in a string literal
> LINE 1: ... '2011-05-05T16:45:58+02:00', '5', '3', 'pint02', ' 5 16:27:...
>                                                              ^
> HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.

So you if I want to use backslash style escaping in strings, I need to
write it this way?

E'Can\'t assign requested address'



-- 
Bazsi