[Twisted-Python] dbcred and Firebird Incompatibility

Joshua Ritter ritterjoshua at msn.com
Wed Oct 23 01:14:04 EDT 2002


First the stuff that makes sense:

---

Firebird doesn't like batched SQL statements in a single string any better
than MySQL does...

Also it doesn't like the Primary Key in dbcred's schema not being specified
as NOT NULL

In twisted_identities:

identity_name     varchar(64) NOT NULL PRIMARY KEY

In twisted_services:

service_name      varchar(64) NOT NULL PRIMARY KEY

---

Now for something weird...

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

-J









More information about the Twisted-Python mailing list