[Twisted-Python] dbcred and Firebird Incompatibility

Joshua Ritter ritterjoshua at msn.com
Wed Oct 23 09:06:58 MDT 2002


"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      |


-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/twisted-python/attachments/20021023/e218e433/attachment.html>


More information about the Twisted-Python mailing list