>> To use this module, you will need these columns in a table
>> called 'sessions':
>>
>> id char(16)
>> length int(11)
>> a_session text
>>
>> which might be ducky for mysql, but on postgresql (7.0.3 anyhow)
>> "length" is illegal as a field name.
"length" is perfectly legal as a field name:
regression=# create table foo (f1 int, length int);
CREATE
The problem is that "int(11)", which is a MySQL-ism through and through;
there is no such construct in SQL92. We'd take "int", or "bigint", or
"int8", or "numeric(11)", or "decimal(11)" ...
regards, tom lane