J. Erik Heinz wrote:
Hi,
i recognized that the session in the
PostgreSQLSessionStorage.class.php will be stored with the following
sql syntax:
// session does not exist, create it
$sql = 'INSERT INTO ' . $db_table . ' (' . $db_id_col . ', ' .
$db_data_col . ', ' . $db_time_col . ') VALUES (' .
'\'' . $id . '\', \'\', ' . time() . ')';
But unfortunatly postgres timestamp has the format like
1999-01-08 04:05:06
Don't use timestamps, the storage is designed to work with an INTEGER
field. This removes some of the overhead with casting ints to timestamp
strings and back.
If you for some reason still want to use timestamp column type, derive
your own PostgreSQLSessionStorage and use date('%c', time()) instead of
time(). Remember to add quotes too.
-veikko
_______________________________________________
agavi-dev mailing list
[email protected]
http://labworkz.com/cgi-bin/mailman/listinfo/agavi-dev
