| From: | Andreas Seltenreich <andreas+pg(at)gate450(dot)dyndns(dot)org> |
|---|---|
| To: | "Thomas Peter" <usenet(at)braindumped(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: strange sql issue |
| Date: | 2006-10-01 11:09:05 |
| Message-ID: | 877izkfg32.fsf@gate450.dyndns.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thomas Peter writes:
> the following sql stopped working with postgres, and the fix of this
> problem seems strange to me.
[...]
> and the fix was, to twist the order in the FROM statement.
> changing
> FROM ticket as t, permission as perm, enum as p
> to
> FROM permission as perm, enum as p, ticket as t
> works like expected!
>
> so is this a bug, or do i get soemthing wrong (a hint where to rtfm would
> be very welcome in this case)
If by "stopped working" you mean that the query returns an unexpected
result set, there should be a difference in the respective query plans
(explain analyze). Comparing them might give a clue what is going
wrong.
regards,
andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Bauer | 2006-10-01 12:08:20 | Re: Major Performance decrease after some hours |
| Previous Message | MaXX | 2006-10-01 10:55:51 | Re: Major Performance decrease after some hours |