Rudder

Several attempt to correct this issue.
On the scala side, 'base becomes 'base in the SQL, and \base becomes \\base

1. the current configuration is 'base and \x08ase
2. with the SQL encoding (rather than stdsql), it does Error and \\base
3. with the SQL encoding (rather than stdsql), string escaped with E, it does Error and \base
4. with the string surrounded by $$ $$, it becomes \base and ''base
5. with the stdsql encoding, string escaped with E, it does 'base and \x08ase
6. with the stdsql and Alter database Rudder set standard_conforming_strings=true; it does \base and 'base (which is better)
7. with the stdsql and Alter database Rudder set standard_conforming_strings=true; and the string escaped with E it does \x08ase and 'base

Altering the standart conforming strings doesn't seems to have any bad side effect (http://www.postgresql.org/docs/8.2/static/runtime-config-compatible.html)

One last attempt :

Alter database Rudder set standard_conforming_strings=false;
$$ $$ string
with an SQL encoding leads to
\\base and \'base

Every modification attemps fails one way or another, with more or less severity (and using sql encoding rather than stdsql leads to security issues)

CFEngine interprets paths on windows with either / or \ the same way, so I guess the best way, for now, is to tell user not to use \, until we can figure out something more robust in the given time

Interestingly enough, given the screen, rudder can or cannot read the \ :
On the technical log page, it does show \tmp\one2 as the key value, but on the reports page, it shows mp\ne2
There is something strange there, that need to be looked at

Nicolas CHARLES wrote:

Interestingly enough, given the screen, rudder can or cannot read the \ :
On the technical log page, it does show \tmp\one2 as the key value, but on the reports page, it shows mp\ne2
There is something strange there, that need to be looked at

I couldn't reproduce this issue.

Apparently, this alone :

alter database rudder set standard_conforming_strings=true;

I have trouble writing the condition on when to do this update, so I'll need an admin for that
The only test I found that seems reliable is :

su - postgres -c "psql -t -d rudder -c \"select '\\foo';\"" | grep "foo" 

On a system with the standard_conforming_strings=true, it will output

 \foo

on a system without the standard_conforming_strings=false, it will output nothing, but the stderr will be filled with warning :

ATTENTION:  utilisation non standard d'un échappement dans une chaîne littérale
LIGNE 1 : select '\foo';
                 ^
ASTUCE : Utilisez la syntaxe de la chaîne d'échappement pour les échappements,
c'est-à-dire E'\r\n'.
 \x0Coo