Re: [GENERAL] Triggers not working
I would have called the Entity table the parent table and not the child table as the Account table inherits from Entity. Therefore it appears that the trigger only works on the table where the actual row was added/belongs to. It would be great if triggers on the parent table would work for any row that appears there, even rows added via a child table. It would mean that any new table that inherits the parent table, in my case Entity, would automatically have the global trigger I want enforced. Nice enhancement :) Regards, Dale Harris. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, 23 September 2008 13:43 To: Dale Harris Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Triggers not working "Dale Harris" <[EMAIL PROTECTED]> writes: > The trigger trAccountUpdate got called, but why didn't the trigger > trEntityUpdate get called? Triggers only apply to the exact table they're declared on, not to child tables. It does seem like there might be some use-case for applying a trigger to child tables too, but that's not how it works now. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Triggers not working
"Dale Harris" <[EMAIL PROTECTED]> writes: > The trigger trAccountUpdate got called, but why didn't the trigger > trEntityUpdate get called? Triggers only apply to the exact table they're declared on, not to child tables. It does seem like there might be some use-case for applying a trigger to child tables too, but that's not how it works now. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Triggers not working
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:[EMAIL PROTECTED] Sent: Monday, 22 September 2008 22:22 To: Dale Harris Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Triggers not working "Dale Harris" <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Triggers not working
"Dale Harris" <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general