On Mon, 2002-02-18 at 12:25, bib wrote: > Der all, > As a newbe using Turbine 2.1, I've made the changes into > tdk/share/conf/torque/templates/sql/base/postgresql/db.props > accordingly messages of Colm and Daniel. > Furthermore, i have updated the postgresql.jar to the v7.2 > binary located at http://jdbc.postgresql.org. > > Now, the "adding user" issue is resolved, but turbine > returns an error when trying to add records in 'RDF' table
The general problem I have found is that when I get blobs working (which is required to save a user) then normal inserts stop working. We use Postgres in Tambora but we don't use Torque so I have never really delved into the problem but it has plagued us for well over a year and no one seems to have a solution that I know of because this issue crops up over and over again. My suggestion would be to remove the blob type from the user schema and don't patch the postgres JAR. The blob column in the user schema is effectively useless any way. > In my little understanding of the engine, RDF_ID > should be considered as "serial" i.e: AUTOINCREMENT insteed > of INTEGER, furthermore idMethod of the table should be set > to 'native' in order to use sequence capabilitie of postgres. > > So, I've made those changes in 'newapp-schema.xml', trying to set > RDF_ID's type to "AUTOINCREMENT". Unfortunatly, I couldn't get > the 'newapp' being initialized correctly (Build Faillure). > I've then play arround with the table property idMethod="native" > without more success. > > Would someone be nice enough in helping me to achieve setup ? > > Many thanks in advance for your tips. > Kindest regards > Bertrand Habib > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- jvz. Jason van Zyl [EMAIL PROTECTED] http://tambora.zenplex.org -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
