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