pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Way <kevin.way@overtone.org>
To: pgsql-sql@postgresql.org
Subject: trigger trouble -- procedure not found
Date: Fri, 14 Sep 2001 04:26:37 +0000
Message-ID: <20010914042637.A65405@bean.overtone.org> (raw)

I'm having trouble creating a trigger.  First i'm creating a function,
add_to_search in PL/pgSQL.

\df verifies the existance of this function:
 smallint                 | add_to_search       | text, text, text, integer

but when I call:

CREATE TRIGGER item_insert_search_add AFTER INSERT
    ON item FOR EACH ROW
    EXECUTE PROCEDURE add_to_search (name, description, reason, node_id);

I get: 
ERROR:  CreateTrigger: function add_to_search() does not exist

What am I missing here?  It seems to me that I'm missing something very
simple, but I can't figure out what it is for the life of me.

Kevin Way



view thread (4+ messages)  latest in thread

Message-ID: <20010914042637.A65405@bean.overtone.org>
Permalink:  ../20010914042637.A65405@bean.overtone.org/
Also on:    postgresql.org/message-id/20010914042637.A65405@bean.overtone.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: kevin.way@overtone.org
  Subject: Re: trigger trouble -- procedure not found
  In-Reply-To: <20010914042637.A65405@bean.overtone.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox