Re: Problem with partitioning

Поиск
Список
Период
Сортировка
От JotaComm
Тема Re: Problem with partitioning
Дата
Msg-id CAA8OQ6_=4_n9=7bkgCUhXkBQuDzjnPJqjU1iAdZ0_LF8Zxb_ZQ@mail.gmail.com
обсуждение исходный текст
Ответ на Problem with partitioning  (JotaComm <jota.comm@gmail.com>)
Ответы Re: Problem with partitioning  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general


2016-08-03 15:20 GMT-03:00 JotaComm <jota.comm@gmail.com>:


2016-08-03 15:15 GMT-03:00 JotaComm <jota.comm@gmail.com>:
Hello,

2016-08-03 14:21 GMT-03:00 David G. Johnston <david.g.johnston@gmail.com>:
On Wed, Aug 3, 2016 at 1:16 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 08/03/2016 10:12 AM, JotaComm wrote:
Hello,

I'm working with partitioning and I have one trigger for insert and
update on parent table, but my trigger is not working for update
operations. The problem is: the trigger is not executed for update just
for insert. I put a raise notice message in my function to verify the
update operation but the raise notice isn't printed on screen.

An answer is contingent on seeing the trigger code.


​And the "CREATE TRIGGER" statement itself...

​I created a specific trigger and the problem persists. The update trigger is not executed. My version is 9.4.​
 

​When I create a trigger for each child table the trigger works very well.​

​Try:

\d+ <tablename> on the relevant table and check/show the "Triggers: " section​.

David J.


​Best regards​

--


​Thank you.​

--



--

В списке pgsql-general по дате отправления:

Предыдущее
От: Moreno Andreo
Дата:
Сообщение: Re: [SPAM] Re: WAL directory size calculation
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Problem with partitioning