| Lists: | pgsql-novice |
|---|
| From: | graeme <graeme_foster(at)sherubtse(dot)edu(dot)bt> |
|---|---|
| To: | PostgreSQL novice list <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Getting a trigger to call a function... |
| Date: | 2004-11-09 09:36:01 |
| Message-ID: | 41908F81.309@sherubtse.edu.bt |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
I'm trying to get a trigger to call a function, without success. Could
someone please direct me to some documentation that would help.
The trigger is called CUpdate() and on the Schema "CIS-Live"
The function is called Log(<some parameters>) and is on the Schema "Logging"
thanks,
graeme.
| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | graeme <graeme_foster(at)sherubtse(dot)edu(dot)bt> |
| Cc: | PostgreSQL novice list <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Getting a trigger to call a function... |
| Date: | 2004-11-09 14:01:40 |
| Message-ID: | 20041109140140.GB4099@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
On Tue, Nov 09, 2004 at 03:36:01PM +0600, graeme wrote:
> I'm trying to get a trigger to call a function, without success. Could
> someone please direct me to some documentation that would help.
We can provide better help if you show what you're doing, describe
what you expect to happen, and show what actually does happen.
The PostgreSQL documentation is here:
http://www.postgresql.org/docs/
Here are some sections concerning triggers:
http://www.postgresql.org/docs/7.4/static/triggers.html
http://www.postgresql.org/docs/7.4/static/plpgsql-trigger.html
http://www.postgresql.org/docs/7.4/static/sql-createtrigger.html
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/