[JS2-160] db.create fails on Postgres

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.0-dev/cvs
• Fix Version/s: 2.0-M4
• Component/s: Project Build
• Environment: Postgres 8.0.0beta4, Windows
• Assignee: Unassigned
• Reporter: John Donald
• Created: 17/Nov/04 04:35
• Updated: 04/Oct/11 21:37
• Resolved: 02/Aug/05 13:59

Description

I'm having Problems with Postgres.

The relation SiteTable has two columns with type BIT.
The default value is an integer, but postgres expects boolean.

So instead of

<!--
Create SiteTable
-->
<table name="SSO_SITE">
<column name="SITE_ID" primaryKey="true" required="true" type="INTEGER"/>
<column name="NAME" required="true" size="254" type="VARCHAR"/>
<column name="URL" required="true" size="254" type="VARCHAR"/>
<column name="ALLOW_USER_SET" default="0" type="BIT"/>
<column name="REQUIRES_CERTIFICATE" default="0" type="BIT"/>
</table>

it would be correct to have:

...
<column name="ALLOW_USER_SET" default="false" type="BIT"/>
<column name="REQUIRES_CERTIFICATE" default="false" type="BIT"/>
...

I guess by simply changing it, other databases may fail.

===
Build output:

db.execute:
[sql] Executing file: C:\usr\jakarta-jetspeed-2\target\src\sql\postgres\security-schema.sql
[sql] [ERROR] Failed to execute: CREATE TABLE SSO_SITE ( SITE_ID integer NOT NULL, NAME varchar (254) NOT NULL, URL varchar (254) NOT NULL, ALLOW_USER_SET b
oolean default 0, REQUIRES_CERTIFICATE boolean default 0, PRIMARY KEY (SITE_ID) )

BUILD FAILED
File...... C:\usr\jakarta-jetspeed-2\maven.xml
Element... sql
Line...... 355
Column.... 39
java.sql.SQLException: ERROR: column "allow_user_set" is of type boolean but default expression is of type integer