Re: update in triggers
От | Mike G. |
---|---|
Тема | Re: update in triggers |
Дата | |
Msg-id | 20050119053441.GA29575@thegodshalls.thegodshalls обсуждение исходный текст |
Ответ на | update in triggers (Jamie Deppeler <jamie@doitonce.net.au>) |
Ответы |
Re: update in triggers
|
Список | pgsql-general |
Isn't the syntax CREATE OR REPLACE FUNCTION chargeratetest() RETURNS "trigger" AS' ? On Wed, Jan 19, 2005 at 03:45:53PM +1100, Jamie Deppeler wrote: > Hi, > > Think im doing something wrong here, cant seem to resolve the problem i > have a trigger which is calling a update function and when it gets to a > update it goes into a infinite loop > > code > > Trigger > CREATE TRIGGER "new_trigger" AFTER INSERT OR UPDATE > ON "chargeratetest" FOR EACH ROW > EXECUTE PROCEDURE "chargeratetest"(); > > > function > > CREATE OR REPLACE FUNCTION "chargeratetest" () RETURNS trigger AS' > begin > > UPDATE chargeratetest > set notes=''hello'' > where new."primary" = chargeratetest."primary"; > > return null; > end; > 'LANGUAGE 'plpgsql' IMMUTABLE CALLED ON NULL INPUT SECURITY INVOKER; > > > would be greatful for any help thx > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
В списке pgsql-general по дате отправления: