From: | Feite Brekeveld <feite(dot)brekeveld(at)osiris-it(dot)nl> |
---|---|
To: | Robert Treat <robertt(at)auctionsolutions(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: trouble with triggers |
Date: | 2001-07-17 16:36:25 |
Message-ID: | 3B546989.E1DC9A38@osiris-it.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Chad R. Larson | 2001-07-17 17:03:14 | Re: Application Design and PostgreSQL |
Previous Message | tamsin | 2001-07-17 16:20:52 | RE: How to find out the weekday from a date??? |