Обсуждение: Exception When Insert Followed By Delete In PL/PGSQL

Hello!

The exception is raised by PL/PGSQL in version
PostgreSQL 7.1.3.:

triggered data change violation on relation
"mastertable"

The code having problem:

DECLARE n smallint;
BEGIN insert into MasterTable values...; SELECT COUNT(*) INTO n FROM DetailTable,MasterTable
WHERE DetailTable.KeyField = MasterTable.KeyField;     IF n = 0 THEN   DELETE FROM MasterTable WHERE ...; --exception
raised END IF;
END;

--------------------------------------------------------
You too can have your own email address from Eurosport.
http://www.eurosport.com

<cnliou@eurosport.com> writes:
> triggered data change violation on relation "mastertable"

The "triggered data change" error check is gone entirely as of 7.2b3.
        regards, tom lane