does not work with pgsql

I get an error when trying to add the authorship module with pgsql.

I get the following errors:

warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "UNSIGNED" at character 39 in /mounts/max
30/home/cath/www/ukra/includes/database.pgsql.inc on line 84.
user warning: query: CREATE TABLE node_authorship (nid INT UNSIGNED NOT NULL DEFAULT 0,authorship VARCHAR(255) NOT NULL DEFAULT
'',profile_real_name SMALLINT DEFAULT 0, PRIMARY KEY (nid),INDEX(authorship(8)) in /mounts/max30/home/cath/www/ukra/includes/d
atabase.pgsql.inc on line 103.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "node_authorship" does not exist in /mounts/max30/home/c
ath/www/ukra/includes/database.pgsql.inc on line 84.
user warning: query: SELECT authorship, profile_real_name FROM node_authorship WHERE nid = 38 in /mounts/max30/home/cath/www/uk
ra/includes/database.pgsql.inc on line 103.