On 07/09/2013 03:05 PM, Alex Decalli wrote:
> I think there is no such table.
There certainly is. From my PostgreSQL logs on the database that RT is
using:
UPDATE sessions SET a_session = $1 WHERE id = $2
with a giant binary blob as $1"
DETAIL: parameters: $1 = 'BQgDAAAACQQRD1
RT should really be using DBD::Pg's native bytea support on PostgreSQL,
not base64-encoding binary for storing in the database, btw, something like:
$rv = $sth->bind_param($param_num, $bind_value,
{ pg_type => DBD::Pg::PG_BYTEA });
per http://search.cpan.org/~rudy/DBD-Pg/Pg.pm
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services