Re: Problem with partitioning
| От | JotaComm |
|---|---|
| Тема | Re: Problem with partitioning |
| Дата | |
| Msg-id | CAA8OQ6-a_3nRtSbRRWCG79JSqYCDm_M9jpdT0sgxphLkzJqkrA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Problem with partitioning (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: Problem with partitioning
Re: Problem with partitioning |
| Список | pgsql-general |
Hello,
2016-08-03 15:29 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com>:
BEGIN
RAISE NOTICE 'update';
UPDATE parent_table SET date=now() WHERE column_id=OLD.column_id;
RETURN NULL;
END;
On 08/03/2016 11:24 AM, JotaComm wrote:
2016-08-03 15:20 GMT-03:00 JotaComm <jota.comm@gmail.com
<mailto:jota.comm@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()
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;
Try:
\d+ <tablename> on the relevant table and check/show the
"Triggers: " section.
David J.--
Adrian Klaver
adrian.klaver@aklaver.com
Thank you
--
JotaComm
http://jotacomm.wordpress.com
http://jotacomm.wordpress.com
В списке pgsql-general по дате отправления: