dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

On 07/11/2011, Jason Pickering <jason.p.pickering@xxxxxxxxx> wrote:
> 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.

OK.  Mind you I don't think we should be running production systems on
ubuntu 11.10.  My recommendation has been to stick with 10.04 LTS with
support through to mid 2015..

>
> 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
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>