On Tue, Aug 14, 2012 at 03:53:08PM +0200, Johannes Renner wrote:
> On 08/14/2012 03:36 PM, Stephen Herr wrote:
> > Johannes,
> >
> > Could you ensure in /usr/share/pgsql/postgresql.conf that bytea_output =
> > 'escape', and if not see if
> > that corrects your problem?
> >
> > -Stephen
>
> Thanks, setting this option fixes the problem on the postgres 9.1 database we
> are using.
>
> We also set standard_conforming_strings = 'off', do you think it makes still
> sense in
Mirek in
https://www.redhat.com/archives/spacewalk-devel/2012-June/msg00023.html
noted that the default changed with 9.1. We did not have time to
investigate what this change could cause.
> combination with bytea_output = 'escape'?
The bytea_output is about output, standard_conforming_strings is about
literals on input.
What I believe needs to be done is set these parameters on the
per-connection basis (if possible) so that we don't depend on
particular PostgreSQL server configuration (and defaults in different
versions).
--
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
