update in triggers

From: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: update in triggers
Date: 2005-01-19 04:45:53
Message-ID: 41EDE601.6000006@doitonce.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-01-19 04:57:32 Re: PL/PgSQL Index Usage with Trigger Variables
Previous Message Tom Lane 2005-01-19 04:45:28 Re: Is initdb needed from 8.0.0rc3 to 8.0.0?