Search Postgresql Archives

Re: Problem with partitioning

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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


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

2016-08-03 14:21 GMT-03:00 David G. Johnston <david.g.johnston@xxxxxxxxx>:
On Wed, Aug 3, 2016 at 1:16 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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.​

--



--

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux