[rsyslog] Postgresql module: standard_conforming_strings

[Jonathan Bond-Caron]

I have two questions:

 

1)      How does rsyslog espace SQL commands in the plugin ompgsql.c?

 

I've been staring at the code but I can't figure out where the backslash
escaping happens. 

 

My problem is I've set:  standard_conforming_strings=On 

This means that the backslash espace ' gfgfdg \'  ' is ignored and causes
errors. There are many ways to fix this. 

 

a)      Have rsyslog issue (SET standard_conforming_strings = off;) for
postgresql 8.2+ (quick fix)

b)      Change default sql espacing to use doubles quotes '' --- so 'test \'
'   becomes     'test ''  '

http://www.postgresql.org/docs/8.1/static/libpq-exec.html#LIBPQ-EXEC-ESCAPE-
STRING

 

2)      Is there an SVN repository of rsyslog? Or does anyone know of a good
way or using GIT on windows (turtoisegit is currently buggy) ?