On Sep 14, Kevin Way wrote:
> 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
>
-- We can verify all the functions which wont return 'OPAQUE'.
> 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
The function executed by a trigger should by default return a
record. ie.. the return type should be 'OPAQUE'.
Try the above..
Hope this will work.
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
