Re: trouble with triggers

Robert Treat wrote:

> [hopefully this isnt a repost, I seem to be haveing an issue getting message
> through]

you create a function first and then a trigger calling that function.
Everything is well documented in the docs coming with postgresql.

Feite

>
>
> I am trying to use the following trigger:
>
> CREATE TRIGGER formatname BEFORE update OR insert ON mytable FOR EACH row
> EXECUTE PROCEDURE lower(name);
>
> however, it gives me the message:
>
> ERROR: CreateTrigger: function lower() does not exist
>
> obviously this does exist, since I can do inserts/updates/selects using
> lower(). I have also tried creating my own version of a lower function but
> it gives me the same message.
>
> Am I missing something? This seems like it should be pretty straightforward.
> tia,
>
> robert
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster