ERROR:
warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "(" LINE 17: taxexempt int(1), ^ in D:\apps\wamp\www\drupal\includes\database.pgsql.inc on line 138.
user warning: query: CREATE TABLE storminvoice ( vid int NOT NULL default 0, nid int NOT NULL default 0, number varchar(50), reference varchar(150), organization_nid int, organization_title varchar(128), project_nid int, project_title varchar(128), requestdate int, duedate int, paymentdate int, amount real, tax real, total real, totalcustomercurr real, taxexempt int(1), PRIMARY KEY (vid, nid) ) in D:\apps\wamp\www\drupal\includes\database.inc on line 515.
The problem is in the query at "taxexempt int(1)", which is a result of schema definition in storminvoice.install at "'taxexempt' => array('type' => 'int', 'length' => 1)," - postgre does not now int(1)
I suggest you use 'taxexempt' => array('type' => 'int', 'size' => 'tiny'). It will map correctly for MySQL as well as for Postgre
Comments
Comment #1
Roberto Gerola commentedFixed and committed.
Many thanks, Roberto.