"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