Re: bytea_output default value change in 9.0 breaks Apache::Session::Postgres - Mailing list pgsql-general

Op 5 okt 2010, om 20:12 heeft Rajesh Kumar Mallah het volgende
geschreven:

> Dear List ,
>
> recent change of bytea_output format from escape to hex in 9.0
> apparently breaks
> popular persistent session handling perl modules like
> Apache::Session::Postgres
> which stores pickled data structures in bytea columns of db table.
> It is difficult to guess the root cause from the exception thrown by
> the said module.
> The problem is fixed by adding
> bytea_output='escape'  in postgresql.conf
> and issuing a pg_ctl reload.
>

You can set this per database, using SQL:

ALTER DATABASE dbname SET bytea_output TO 'escape';

>
> Eg in RT application the error is:
> error:  RT couldn't store your session.
> This may mean that that the directory /blah/blah/foo/bar isn't
> writable or a database table is missing or corrupt
>
> Regds
> Rajesh Kumar Mallah.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


Regards,
Frank Heikens