Re: [GENERAL] Need help to identify stray row in a table

2010-04-23 Thread சிவகுமார் மா
2010/4/23 Merlin Moncure : > > There's way too much logic going on there for me to test all the > different cases. > > I suspect this is your problem: you triggered a case somehow which is > not handled properly via your labyrinth of switches and loops.  I > highly doubt this is a case of database

Re: [GENERAL] Need help to identify stray row in a table

2010-04-23 Thread Merlin Moncure
2010/4/23 சிவகுமார் மா : > 2010/4/23 Merlin Moncure : >> >> You haven't given enough information to make any sort of reasonable >> diagnosis.  Most people are going to assume the problem is on your end >> but it's possible to know for sure without having the trigger function >> at the very least. >

Re: [GENERAL] Need help to identify stray row in a table

2010-04-23 Thread சிவகுமார் மா
2010/4/23 Merlin Moncure : > > You haven't given enough information to make any sort of reasonable > diagnosis.  Most people are going to assume the problem is on your end > but it's possible to know for sure without having the trigger function > at the very least. > Thanks merlin for the reply. T

Re: [GENERAL] Need help to identify stray row in a table

2010-04-23 Thread Merlin Moncure
2010/4/23 சிவகுமார் மா : > 1. We have a production system tracking value added to a batch through > series of stages. Value table is updated through triggers on  data > tables. > > 2. These trigger functions have been tested and validated for over 1.5 > years with more than 100,000 records. > > 3.