Re: different results based solely on existence of index (no, seriously)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Matthew Dennis" <mdennis(at)merfer(dot)net>
Cc: PGSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: different results based solely on existence of index (no, seriously)
Date: 2008-08-12 15:34:20
Message-ID: 7602.1218555260@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

"Matthew Dennis" <mdennis(at)merfer(dot)net> writes:
> In reference to the script below (I know it can be rewritten, that's not the
> point), I get 3 rows if the referenced index exists but only two rows if it
> does not.

I don't see any failure in 8.3 branch tip. I think the bug was fixed
here:
http://archives.postgresql.org/pgsql-committers/2008-06/msg00336.php

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2008-08-12 18:30:55 Re: BUG #4350: 'select' acess given to views containing "union all" even though user has no grants
Previous Message Heikki Linnakangas 2008-08-12 15:26:50 Re: BUG #4350: 'select' acess given to views containing "union all" even though user has no grants

Browse pgsql-general by date

  From Date Subject
Next Message Lennin Caro 2008-08-12 15:38:09 Re: automatic REINDEX-ing
Previous Message Daneel 2008-08-12 15:25:17 Newbie [CentOS 5.2] service postgresql initdb