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