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

Roberto Gerola’s picture

Assigned: Unassigned » Roberto Gerola
Status: Active » Fixed

Fixed and committed.

Many thanks, Roberto.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.