"Elliott Groszek" <elliott(dot)groszek(at)navy(dot)mil> writes:
> The following SQL statements produce different query plans even though
> "phone" is not reference in the SQL!
> explain update customer set login_name =
> (select "NESSOuserName" from person,phone
> where person.cac_cert=customer.cac_cert);
> explain update customer set login_name =
> (select "NESSOuserName" from person
> where person.cac_cert=customer.cac_cert);
That's not a bug.
regards, tom lane