Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Triggers in Postgres
- From: Richard Huxton <dev(at)archonet(dot)com>
- To: Jasbinder Bali <jsbali(at)gmail(dot)com>
- Cc: Tino Wildenhain <tino(at)wildenhain(dot)de>, pgsql-general(at)postgresql(dot)org
- Subject: Re: Triggers in Postgres
- Date: Mon, 31 Jul 2006 17:25:01 +0100
Jasbinder Bali wrote:
Actually Postgres manual of triggers says that in postgres, you can't write a trigger in conventional sql. You have to write it in a procedural language like C. So wanted some more insight on it.
See chapters 35 - 39 of the manual for details. In particular a discussion of plpgsql and an example of writing a trigger using it.
http://www.postgresql.org/docs/8.1/static/plpgsql.htmlThere are other procedural languages available too: php, ruby, shell, R, all of various levels of maturity and with different features.
-- Richard Huxton Archonet Ltd
- References:
- Triggers in Postgres
- From: Jasbinder Bali
- Re: Triggers in Postgres
- From: Tino Wildenhain
- Re: Triggers in Postgres
- From: Jasbinder Bali
- Triggers in Postgres
- Prev by Date: pg_xlog not cleaned up
- Next by Date: Re: Antw: Re: Query questions
- Previous by thread: Re: Triggers in Postgres
- Next by thread: Query questions
- Indexes: