Re: Index not used in functions in 7.0? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Index not used in functions in 7.0?
Date
Msg-id 21401.958492203@sss.pgh.pa.us
Whole thread Raw
In response to Index not used in functions in 7.0?  (Kyle Bateman <kyle@actarg.com>)
Responses Re: Index not used in functions in 7.0?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Kyle Bateman <kyle@actarg.com> 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


pgsql-sql by date:

Previous
From: Kyle Bateman
Date:
Subject: Index not used in functions in 7.0?
Next
From: mig@utdt.edu
Date:
Subject: Re: pattern matching operator