| 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: | Whole Thread | Raw Message | 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
| 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? |