Re: [GENERAL] create triggers.

2003-10-20 Thread Oliver Elphick
On Sun, 2003-10-19 at 22:51, Ling Xiaoyu wrote: > Hello there. > Can anybody help me with Postgresql triggers? > what I need is a trigger which update value of field > "tables_rows.total_rows" to rows count of table > "zzz" if I insert new row in table "zzz"... > > CREATE TABLE zzz ( > ... >

[GENERAL] Create Triggers Documentation Error

2000-04-29 Thread john huttley
Quite a few people (including me) have had problems with creating triggers. Last week Jan gave us the definative answer. No, trigger procedures in Postgres are allways defined to take no arguments and have a return type "opaque". The main error above is, that the "sql" language c