Re: Problem with a rule on upgrade to v7.1.1

Jon Lapham <lapham@extracta.com.br> writes:
> I didn't do Pgv7.0.3 b/c I think it may be unnecessary
> since 7.1RC1 doesn't show this problem, while 7.1.1 does.  But, if you
> really think it necessary, I will repeat his using 7.0.3.

No, that seems like useless work.

> 1) As usual, the 7.1RC1 returns from the "UPDATE ... " command as fast
> as I press enter.  The 7.1.1 returns from the "UPDATE ... " command in
> about 10 minutes.
> 2) The two explains are identical.

Oh, *that's* interesting.

> 5) There are 8664 and 3680 tuples in the "tplantorgan" and "tplant" tables 
> respectively.  So this is a relatively small DB.

Would you be willing to send me a dump of the whole DB (or at least the
tables needed for this query)?
        regards, tom lane