You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Markus Strauß <ma...@klt-ag.de> on 2003/02/13 08:27:38 UTC

AW: More on PostgreSQL and Jetspeed 1.4b3 (2)

sorry - i sent that too early...

so: make sure your target database is switched to:
torque.database=postgresql (in the /torque/build.properties file)

and change your security shema.xml file (in torque/schema) so tha you
use not the "native" id-method attribute, but the "idbroke", something
like that:
  <!--<table name="TURBINE_USER" idMethod="native" >-->
   <table name="TURBINE_USER" idMethod="idbroker" >
     <!--<column name="USER_ID" required="true" primaryKey="true"
autoIncrement="true" type="INTEGER"/>-->
     <column name="USER_ID" required="true" primaryKey="true"
type="INTEGER"/>

and do this for all tables.

when rebuilding jetspeed you should find a security-schema.sql which
would do the trick. in the sec-schema.sql i sent already i simply copied
the coffee-table into it. works fine with me

hth 

and again sorry for the "broken" message (stupid outlook)


markus

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org