On 08/03/2016 12:11 PM, JotaComm wrote:
Hello,
2016-08-03 15:29 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>:
On 08/03/2016 11:24 AM, JotaComm wrote:
2016-08-03 15:20 GMT-03:00 JotaComm <jota.c...@gmail.com
<mailto:jota.c...@gmail.com>
<mailto:jota.c...@gmail.com <mailto:jota.c...@gmail.com>>>:
When I create a trigger for each child table the trigger
works very
well.
Without seeing any code this problem is not going to be solved.
The trigger code:
tg_table_update AFTER UPDATE ON parent_table FOR EACH ROW EXECUTE
PROCEDURE f_table_update()
CREATE OR REPLACE FUNCTION f_table_update()
RETURNS TRIGGER AS $$
BEGIN
RAISE NOTICE 'update';
UPDATE parent_table SET date=now() WHERE column_id=OLD.column_id;
RETURN NULL;
END;
$$ LANGUAGE PLPGSQL;
In addition to what Tom said:
This is an AFTER UPDATE trigger so the original UPDATE already occurred.
Is it is expected that the OLD.column_id would still be around in the table?
The fact that you are not seeing the RAISE NOTICE 'update' could be
explained by logging settings.
Try:
\d+ <tablename> on the relevant table and check/show the
"Triggers: " section.
David J.
--
JotaComm
http://jotacomm.wordpress.com
--
JotaComm
http://jotacomm.wordpress.com
--
Adrian Klaver
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
Thank you
--
JotaComm
http://jotacomm.wordpress.com
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
