Hi, On Mon, Nov 17, 2003 at 12:36:15PM +0200, Atanas Karashenski wrote:

I use otrs powered by Postgresql. Somehow I got broken relationships. I would like to use foreign keys in PG in order to prevent those kind of problems.

So the question is: Is there a version of /usr/opt/otrs/scripts/database/otrs-schema.xml (generates sql statements by Turbine/Torque) which uses "foreign-key" and/or "reference" elements for foreign keys definition.

Sorry, there is no otrs-schema.xml with foreign-key. I'm not sure if Turbine/Torque is supporting this. :-/ But if you have more infos... :)

Thanks, Atanas Karashenski

Martin -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388