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: | Raw Message | Whole Thread | 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 |