>> The problem is that table qualifications are left>> off the fieldnames in both the SELECT clause and the WHERE clause.
Yes, that was reported and fixed a while ago. It's definitely incurrent and 6.5.2, not sure about 6.5.1.
regards, tom lane