| From: | Dan Jewett <danjewett(at)mac(dot)com> | 
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org | 
| Subject: | function does not exist error... | 
| Date: | 2002-11-21 19:14:03 | 
| Message-ID: | p05200f02ba02df1d4182@[162.84.132.56] | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-novice | 
Can someone help me figure out why my trigger can't meet my function? 
Other than the obvious reason that I'm a total beginner, and I don't 
know what the heck I'm doing. :-)
After I got the CreateTrigger error, I reran the CreateFunction query 
just to see what would happen:
recordings=> CREATE FUNCTION check_participant(varchar) RETURNS opaque AS '
	DECLARE name ALIAS FOR $1;
	BEGIN
	SELECT fname FROM participant WHERE fname = name; IF FOUND 
THEN RETURN 0;
	ELSE INSERT INTO artist (fname) VALUES (name); END IF; END;' 
LANGUAGE 'plpgsql';
ERROR: function check_participant already exists with same argument types
recordings=> CREATE TRIGGER trigger_artist BEFORE INSERT ON participant
	FOR EACH ROW EXECUTE PROCEDURE check_participant();
ERROR: CreateTrigger: function check_participant() does not exist
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2002-11-21 21:33:16 | Re: function does not exist error... | 
| Previous Message | Tom Lane | 2002-11-21 16:04:13 | Re: Error when creating a char column as primary key |