Re: change the order of FROM selection to make query work

"Thomas Peter" <usenet@braindumped.com> writes:
> i support a trac [1] installation and migrated the backend from sqlite to
> postgres 8.1.4, which worked fine, but:
> the following sql stopped working with postgres,

Define "stopped working" ... what was wrong exactly?

Changing the FROM order should certainly not have made any semantic
difference.  It's possible that it would have changed the plan chosen,
but unlikely (unless maybe the planner had no statistics to go on?)

            regards, tom lane