Creating tables after installation with Postgres, I get this error:

  • warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "unsigned" at character 86 in /var/www/html/drupal-5.10/includes/database.pgsql.inc on line 125.
  • user warning: query: CREATE TABLE node_field_multireference_data ( id SERIAL, nid integer unsigned NOT NULL default '0', vid integer unsigned NOT NULL default '0', reference varchar(32) NOT NULL default '', field_name varchar(32) NOT NULL default '', r_id integer unsigned NOT NULL default '0', r_text varchar(255) NOT NULL default '', description varchar(255) NOT NULL default '', description2 varchar(255) NOT NULL default '', weight integer default NULL, PRIMARY KEY (id) ) in /var/www/html/drupal-5.10/includes/database.pgsql.inc on line 144.

I am not really a Postgres expert, but some quick googling indicated that it does not support unsigned datatypes. I just removed the "unsigned" keywords and re-executed the query, and it seemed to work (so far so good, at least).