From: | Amit Kapila <amit(dot)kapila(at)huawei(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | In one of negative test row-level trigger results into loop |
Date: | 2012-09-24 14:03:11 |
Message-ID: | 00ff01cd9a5d$55f57c80$01e07580$@kapila@huawei.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Below test results into Loop:
1.create test table
CREATE TABLE TEST_TABLE (NAME VARCHAR2, AGE INT);
2.create trigger function
CREATE OR REPLACE FUNCTION TRIG_FUNC () RETURNS TRIGGER AS
$$
DECLARE
PSQL VARCHAR2;
BEGIN
Raise info 'This is Test!!!';
psql:= 'INSERT INTO TEST_TABLE VALUES(''john'', 25);';
execute psql;
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
3.create trigger
CREATE TRIGGER TEST_TRIGGER AFTER INSERT OR UPDATE OR DELETE ON TEST_TABLE
FOR EACH ROW
EXECUTE PROCEDURE TRIG_FUNC ();
4.Perform an insert statement
INSERT INTO TEST_TABLE VALUES('jack',25);
Now, You will see an always loop.
I understand that user can change his code to make it proper.
However shouldn’t PostgreSQL also throws errors in such cases for recursion
level or something related?
With Regards,
Amit Kapila.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2012-09-24 14:14:00 | Re: In one of negative test row-level trigger results into loop |
Previous Message | David Johnston | 2012-09-24 13:57:09 | Re: Prolem to acess PostgeSQL from other mechine |