Postgres Pro
Downloads
Home   >   mailing lists

Re: create index on function - why? - Mailing list pgsql-sql

From Tom Lane
Subject Re: create index on function - why?
Date
Msg-id 15109.1013796914@sss.pgh.pa.us
Whole thread Raw
In response to Re: create index on function - why?  ("David Huselid" <dhuselid@pepperdash.com>)
List pgsql-sql
Tree view 
"David Huselid" <dhuselid@pepperdash.com> writes:
> PostgreSQL 7.0.2

You need to update ...

> But I am getting the following error:
> ERROR: DefineIndex: function 'upper(varchar)' does not exist

7.0.* is quite picky about index functions; there has to be an exact
match in pg_proc, not just a binary-compatible match.  You could work
around this by creating a pg_proc entry for upper(varchar) that matches
the one for upper(text) ... but I'd suggest updating instead.
        regards, tom lane

pgsql-sql by date:

Previous
From: Bill Cunningham
Date:
Subject: Re: SQL For smarties
Next
From: Benoit Menendez
Date:
Subject: Problem with self-join updates...