Thread: bytea_output default value change in 9.0 breaks Apache::Session::Postgres

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.


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.

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