[BUGS] Bug #440: trigger can not find a function

2001-09-06 Thread pgsql-bugs
arnauld michelizza ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description trigger can not find a function Long Description ERROR: CreateTrigger: function check_key() does not exist Sample Code CREATE FUNCTION check_key(varchar,varc

Re: [BUGS] Bug #440: trigger can not find a function

2001-09-06 Thread Stephan Szabo
> Sample Code > CREATE FUNCTION check_key(varchar,varchar) RETURNS OPAQUE AS ' > BEGIN > IF COUNT(*) FROM $2 WHERE $2.$1=NEW.$1 THEN >RAISE EXCEPTION ''integrity violation : duplicated key''; > END IF; > RETURN NEW; > END; > ' LANGUAGE 'plpgsql'; > > CREATE TRIGGER trigger_