Further to my initial email, I raised a case with Tech Support and their
initial response was "It is advisable to drop constraints triggers and
stored procedures due to any potential changes to the catalog tables that
may cause conflicts to occur during the migration", which is rather alarming
and not something I'd want to do considering the number of constraints there
are in the DB.

Can anyone add anything to this?



Regards

Colin

There are 10 types of people in the world, those that understand binary and
those that don't





>From: "Colin Dawson" <cjd_1955@hotmail.com>
>To: informix-list@iiug.org
>Subject: 9.40.FC8 and TRIGGERS
>Date: Wed, 05 Jul 2006 10:20:58 +0000
>
>We upgraded a server from 7.31.FD7 to 9.40.FC8, the stored procedures were
>all dropped/recreated as advised by Informix however we seem to have come
>across another problem in that an update trigger that invokes 3 stored
>procedures was failing (hence my question yesterday about SP's). We dropped
>the trigger and recreated it and everything now works perfectly. Am I right
>to surmise that triggers are affected by a V9 migration in the same way
>stored procedures are?
>
>
>
>
>Regards
>
>Colin
>
>There are 10 types of people in the world, those that understand binary and
>those that don't
>
>_________________________________________________ ________________
>Windows Live™ Messenger has arrived. Click here to download it for free!
>http://imagine-msn.com/messenger/launch80/?locale=en-gb
>


>_______________________________________________
>Informix-list mailing list
>Informix-list@iiug.org
>http://www.iiug.org/mailman/listinfo/informix-list

__________________________________________________ _______________
The new MSN Search Toolbar now includes Desktop search!
http://join.msn.com/toolbar/overview