Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: change the order of FROM selection to make query work
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Thomas Peter" <usenet(at)braindumped(dot)com>
- Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
- Subject: Re: change the order of FROM selection to make query work
- Date: Tue, 26 Sep 2006 09:35:07 -0400
"Thomas Peter" <usenet(at)braindumped(dot)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
- Follow-Ups:
- Re: change the order of FROM selection to make query work
- From: Thomas Peter
- Re: change the order of FROM selection to make query work
- References:
- change the order of FROM selection to make query work
- From: Thomas Peter
- change the order of FROM selection to make query work
- Prev by Date: Re: Restart after poweroutage
- Next by Date: Re: Dead Lock problem with 8.1.3
- Previous by thread: change the order of FROM selection to make query work
- Next by thread: Re: change the order of FROM selection to make query work
- Indexes: