you mention you use one update statement by record, this may be to
basic but anyway, it just happened to me...
do you use the WHERE clause in your UPDATE statement, and if so is the
column you use to filter indexed?
javier
On Sat, 5 Feb 2005 03:14:52 -0800 (PST), Venkatesh Babu
<[EMAIL PROTECTE
How are you updating this tables? Do you use UPDATE WHERE
On Fri, 4 Feb 2005 05:57:32 -0800 (PST), Venkatesh Babu
<[EMAIL PROTECTED]> wrote:
> Hello,
>
> We have a table cm_quotastates which has exactly
> 4624564 rows and 25 columns and 9 indexes... Out of
> these, our code retrieves 7
when i upgraded from 7.4 to 8 many of my functions no loger worked,
they all had something in common:
DECLARE
produto RECORD;
BEGIN
FOR producto IN SELECT producto FROM p LOOP
the error reported was: record "producto" is not assigned yet
i finally realized that name of the variable can no lo
