Hello all, I am trying to get a TDK2.1 app running on postgreSQL 7.1.2 and have run across a few problems... Things I've found so far:
- postgreSQL should be >= v7.0 or else the torque-generated constraint-defining SQL doesn't work - the ALTER TABLE ADD CONSTRAINT syntax wasn't around before this. - db.props should be fetched from CVS or hand-edited to add the extra type mappings (e.g. int8 for bigint). I am using text for CLOB. However, some things have got me stumped: - When extending the turbine_user table by adding an alias as suggested in the Extend TurbineUser Howto, pgsql seems confused by the references to this alias name, stating that the table doesn't exist (which is true). Could anyone shed any light on what is going on under the covers with this system? - when creating a table with a composite primary key (i.e. more than one column involved) pgsql rejects any foreign key relationships with that table. It seems to expect that there should a unique constraint on each of the referenced columns whereas they are unique, of course, only in combination... I could create a false (e.g. auto-incremented) unique key for this table but would rather not. Finally, would people with experience of pgsql recommend a manual database build instead? Many thanks for any help, colm -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
