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