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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Regards,
Frank Heikens
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
