> I am hoping that there is a simple omission that keeps the optimizer
> from using the transitive literal.
PG doesn't compute transitive equality of literals, and never has AFAIK
(certainly 7.0.* didn't). I'm not sure what's causing the change in
behavior from 7.0 to 7.1, but your theory about it is wrong. Could you
make up a self-contained example?
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Panon, Paul-Andre||Date: 2001-05-26 01:06:48|
|Subject: SQL update statements are failing if submitted in sequence on same connection|
|Previous:||From: Arcady Genkin||Date: 2001-05-25 20:54:11|
|Subject: Compilation --with-python fails on Solaris 8|