| From: | "J(dot)H(dot)M(dot) Dassen (Ray)" <jdassen(at)cistron-office(dot)nl> |
|---|---|
| To: | pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: automated log-messages |
| Date: | 2001-01-12 07:43:32 |
| Message-ID: | 20010112084332.A17096@cistron-office.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Fri, Jan 12, 2001 at 07:59:26 +0100, Joern Muehlencord wrote:
> I am trying to implement an automated log-message system for my
> application. For example, if a new user is inserted to my table "auth",
> I want to create a log message like: "user [name] added to system". Is
> it possible to add this message with triggers or rules?!
It can be done using a trigger procedure in Pl/pgSQL, using a "RAISE"
statement; see
http://postgresql.rmplc.co.uk/devel-corner/docs/postgres/plpgsql-description.htm#AEN6187
HTH,
Ray
--
"The proper place for a CAPSLOCK key is in a different hemisphere from you."
Tom Christiansen in "Interface Zen",
http://slashdot.org/article.pl?sid=99/11/30/0954216
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Wagner | 2001-01-12 09:22:16 | Re: [SQL] connecting to postgres server from Access |
| Previous Message | Joern Muehlencord | 2001-01-12 06:59:26 | automated log-messages |