Untrusted functions on index creation.

Hi,

I want a case independent index on people's names and am having troubles.

Here is some output from a postgres run:

/*
 * First lets drop the tables and index
 */
drop index upper_name ;
drop function myupper (text);
drop table prosb;
drop sequence prosb_brief_seq;
/*
 * now make them
 */
create table prosb (
    animal_s    text,
    brief serial primary key,
    defendant_name text ,
    payment_received text
    ... ETC
);
NOTICE:  CREATE TABLE will create implicit sequence prosb_brief_seq for SERIAL column prosb.brief
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index prosb_pkey for table prosb
CREATE
create function
    myupper (text)
    returns text
        AS 'SELECT upper($1);' LANGUAGE 'sql';
CREATE
/*
 * the index creation works fine
 */
create index upper_name on prosb (myupper(defendant_name) varchar_ops);
CREATE

insert into prosb (animal_s, defendant_name) values('cat','John');
ERROR:  internal error: untrusted function not supported.
insert into prosb (animal_s, defendant_name) values('cat','Steven');
ERROR:  internal error: untrusted function not supported.
insert into prosb (animal_s, defendant_name) values('dog','Mike');
ERROR:  internal error: untrusted function not supported.

I tried using plpgsql instead of sql, but PG tells me the language isn't
registered.

Cheers,
Geoff,

geoff@austrics.com.au            | Phone: +618-8332-5069
6 Fifth Ave, St Morris, SA 5068  |   Fax: +618-8364-1543