"password" and "user" are Firebird/Interbase keyword/variables... neither will work as a column name... for instance, you also can't have a column named "file", "default","starting", "length", etc etc etc. This is pretty enough for me: identity_name identity_password I wonder what other landmines await... -J ----------------------------------------------------

...

Firebird chokes in CREATE TABLE twisted_identities on the password column... by changing the name to identity_password it works?!?!?!?!?

It's almost certainly wrong, but the first thing that occurs to me is:

twistedidentities identitypassword ^ ^ ^ ^ ^ 4 8 12 16 18

twisted_identities has more than 16 alphanumeric characters in it, whereas identity_password has exactly 16. Is this a hard limit in firebird, by chance? ;-)

-- | <`'> | Glyph Lefkowitz: Travelling Sorcerer | | < _/ > | Lead Developer, the Twisted project | | < ___/ > | http://www.twistedmatrix.com |