Hi Tom,
The trigger trAccountUpdate got called, but why didn't the trigger
trEntityUpdate get called?
Regards,
Dale Harris.
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, 22 September 2008 22:22
To: Dale Harris
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Triggers not working
"Dale Harris" <itsupport@jonkers.com.au> writes:
> I'm running PostgreSQL 8.3.3 and I'm having trouble with triggers not
always
> working. I have the following tables and functions as documented below.
My
> problem is that if I perform an update on the Entity table and modify the
> Code field, why doesn't the trigger for the Entity table execute? (Row
was
> initially added via the Account table.)
Worksforme ...
regression=# insert into "Account" values(1,'code','name');
INSERT 0 1
regression=# select * from "Entity";
ID | Code | Name | Modified | ModifiedBy
----+------+------+---------------------------+------------
1 | code | name | 2008-09-22 08:19:51.70-04 | postgres
(1 row)
regression=# update "Entity" set "Code" = 'foo' where "ID" = 1;
NOTICE: trAccountUpdate being called for UPDATE of Account.
UPDATE 1
regression=# select * from "Entity";
ID | Code | Name | Modified | ModifiedBy
----+------+------+---------------------------+------------
1 | foo | name | 2008-09-22 08:20:18.10-04 | postgres
(1 row)
regards, tom lane
