how is this supposed to work?

i made twitter work on drupal 6.10 with postgres.

for this, i first had to patch the pgsql driver due to the
unsigned issue you pointed out elsewhere, ok.

but your module failed for other reasons. in the installer,
you request column "uid" of twitter_user to be "not null",
but your code executes a query that will INSERT INTO
only column "screen_name" and "import". of course
this query will fail (on postgres at least).

so ... any specific reason why "uid" must be "not null"
if you run a two-step creation on it later? when setting
it to "not null => FALSE", everything works and the
module inserts the right uid (i assume in a second step).