From 13938186203ef7181d437ee11e699199d5d9d9aa Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Sun, 24 Feb 2008 20:30:59 +0000
Subject: Adding explicit cast to md5() so it will work on Pg 8.3

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2085 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/modules/Session.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/sql/modules/Session.sql b/sql/modules/Session.sql
index 58de0f2e..8b8b65c6 100644
--- a/sql/modules/Session.sql
+++ b/sql/modules/Session.sql
@@ -28,7 +28,7 @@ BEGIN
 			
 		END IF;
 		INSERT INTO session(users_id, token, last_used, transaction_id)
-		SELECT id, md5(random()), now(), 0 
+		SELECT id, md5(random()::text), now(), 0 
 		  FROM users WHERE username = SESSION_USER;
 		-- TODO-- remove transaction_id field from session table
 
-- 
cgit v1.2.3