[GENERAL] Untrusted functions on index creation.

[Geoff Russell]

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,

[EMAIL PROTECTED]            | Phone: +618-8332-5069
6 Fifth Ave, St Morris, SA 5068  |   Fax: +618-8364-1543


************