dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

OK. I managed to get to the bottom of this, as it was not happening in
previous versions of Postgresql.

The default postgres version on Ubuntu 11.10 is 9.1.

Somewhere ( I am not 100% sure, but suppose quick) the quotes are
being escaped with back slashes. This is sort of fine in earlier
version of Postgresql, but not with 9.1 at least with the default
settings. In order to get this to work with 9.1, you need to edit your
postgresql.conf file


backslash_quote = on    # on, off, or safe_encoding. Default in 9.1 is
safe_encoding.
standard_conforming_strings = off # Default in 9.1 is ON

This is a workaround until this gets fixed properly.

Regards,
Jason