Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA04190 for ; Tue, 16 May 2000 11:50:12 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id LAA21404; Tue, 16 May 2000 11:50:04 -0400 (EDT) To: Kyle Bateman cc: pgsql-sql@postgresql.org, merrill@actarg.com Subject: Re: Index not used in functions in 7.0? In-reply-to: <3921689A.B70CFAC8@actarg.com> References: <3921689A.B70CFAC8@actarg.com> Comments: In-reply-to Kyle Bateman message dated "Tue, 16 May 2000 09:26:18 -0600" Date: Tue, 16 May 2000 11:50:03 -0400 Message-ID: <21401.958492203@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200005/12 Kyle Bateman writes: > I dumped the log (-d 9) from the postmaster and the plan confirms that > the scan is sequential when called from within the function but indexed > when the SQL is called directly. Yikes, that does sound like a bug. > I'd be happy to provide a dump of the data, do other testing or whatever > would help. I'm not sure who on the team is best to look at this. How big would the dump file be? I'm willing to look at this, and if the dump isn't very large then it'd be easier to just install your DB here instead of trying to gin up my own test case. regards, tom lane