The following comment has been added to this issue:
Author: Ken Geis
Created: Wed, 13 Oct 2004 12:49 PM
Body:
The PostgreSQL scripts are generated with type bytea for the Torque type LONGVARCHAR.
Torque isn't happy with the bytea type though. They should be type text. This type
was implemented in Postgres 7.0 several years ago, and unfortunately it shows that
Torque does not have first class support for Postgres.
I haven't found a way to coax Torque into doing the right thing, so we may need to
involve the Torque team. The Torque DB adapter should be brought up to date, and
maybe a legacy adapter should be made for PostgreSQL versions less than 7.0.
Also, the populate-entities-for-default-psml.sql does not work for PostgreSQL because
it does not implicitly cast integer to boolean. I will submit a patch soon.
---------------------------------------------------------------------
View this comment:
http://issues.apache.org/jira/browse/JS2-128?page=comments#action_54012
---------------------------------------------------------------------
View the issue:
http://issues.apache.org/jira/browse/JS2-128
Here is an overview of the issue:
---------------------------------------------------------------------
Key: JS2-128
Summary: Add PostgresSQL and MS SQL to Torque scripts generation.
Type: Task
Status: Closed
Priority: Minor
Resolution: FIXED
Project: Jetspeed 2
Components:
Project Build
Fix Fors:
2.0-dev/cvs
2.0-a1
Versions:
2.0-dev/cvs
2.0-a1
Assignee: Scott T Weaver
Reporter: Scott T Weaver
Created: Tue, 28 Sep 2004 7:27 AM
Updated: Wed, 13 Oct 2004 12:49 PM
Environment: All
Description:
Add PostgresSQL and MS SQL scripts to Torque generation.
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
