That is probably because you created test2(INTEGER) and you're trying to call test2(TEXT).
On Wed, Dec 01, 2004 at 11:22:41AM +1100, Jamie Deppeler wrote: > Hi , i have designed a trigger function called test2(Integer) > > im trying to use it with a trigger but get errors that function cannot > be found > > Trigger statement is > > CREATE TRIGGER "new_trigger566" BEFORE INSERT > ON "customer" FOR EACH ROW > EXECUTE PROCEDURE test2("primary"); > > > get the error test2() cannot be found > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]