On Jan 30, 2008 12:39 PM, R Summers <
..hidden..> wrote:
I experienced the same problem. There seems to be some difference between PostgreSQL 8.3 and previous versions; this requires an explicit cast...
Modify the file DB.pm by changing line 160 from:
my $fetchSequence = $dbh->prepare("SELECT nextval('session_session_id_seq'), md5(random());");
to:
my $fetchSequence = $dbh->prepare("SELECT nextval('session_session_id_seq'), md5(random()::text);");
Notice the change 'md5(random()::text)' which is an explicit cast from double to text by PostgreSQL so that md5() can accept it. I reported this in the developers list today.
Already fixed in svn today.
This was a change by design in PostgreSQL 8.3.
Best Wishes,
Chris Travers