Upon installation of Jira 2 the following exception occurs on startup:

2003-03-16 18:46:06,543 ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE TABLE portletconfiguration (ID NUMERIC(18,0) NOT NULL, PORTALPAGE NUMERIC(18,0), PORTLET_ID VARCHAR(255), COLUMN_NUMBER NUMERIC(9,0), POSITION NUMERIC(9,0), CONSTRAINT PK_portletconfiguration PRIMARY KEY (ID))
Error was: java.sql.SQLException: ERROR: parser: parse error at or near "POSITION"

It seems POSITION is a reserved word in Postgres 7.1.3. I tried this:

> CREATE TABLE TEST (hello VARCHAR(10))
OK

> CREATE TABLE TEST2 (position VARCHAR(10))
ERROR: parser: parse error at or near "position"

I am using field-type-name="postgres" in entityengine.xml (not "postgres72" as this fails with unknown type: TIMESTAMPTZ)