Posted by scottgifford on February 5, 2009 at 3:56am
| Project: | Multireference CCK field |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
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).