Re: [GENERAL] Problem with partitioning

On 08/03/2016 12:11 PM, JotaComm wrote: Hello, 2016-08-03 15:29 GMT-03:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>>: On 08/03/2016 11:24 AM, JotaComm wrote: 2016-08-03 15:20 GMT-03:00 JotaComm mailto:jota.c...@gmail.com>

Re: [GENERAL] Problem with partitioning

JotaComm writes: >​The trigger code: > tg_table_update AFTER UPDATE ON parent_table FOR EACH ROW EXECUTE PROCEDURE > f_table_update() I'm fairly sure that per-row triggers only fire on events in their table, ie this would fire on updates to rows in parent_table itself, but not on updates to ro

Re: [GENERAL] Problem with partitioning

Hello, 2016-08-03 15:29 GMT-03:00 Adrian Klaver : > On 08/03/2016 11:24 AM, JotaComm wrote: > >> >> >> 2016-08-03 15:20 GMT-03:00 JotaComm > >: >> >> > >> ​When I create a trigger for each child table the trigger works very >> well.​ >> > > ​​ > Without seeing

Re: [GENERAL] Problem with partitioning

On 08/03/2016 11:24 AM, JotaComm wrote: 2016-08-03 15:20 GMT-03:00 JotaComm 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. ​Try:

Re: [GENERAL] Problem with partitioning

2016-08-03 15:20 GMT-03:00 JotaComm : > > > 2016-08-03 15:15 GMT-03:00 JotaComm : > >> Hello, >> >> 2016-08-03 14:21 GMT-03:00 David G. Johnston >> : >> >>> On Wed, Aug 3, 2016 at 1:16 PM, Adrian Klaver >> > wrote: >>> On 08/03/2016 10:12 AM, JotaComm wrote: > Hello, > > I'm

Re: [GENERAL] Problem with partitioning

On Wed, Aug 3, 2016 at 1:16 PM, Adrian Klaver 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 no

Re: [GENERAL] Problem with partitioning

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

[GENERAL] Problem with partitioning

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

[GENERAL] problem with partitioning and indexed order by

hii have a table with 14 milion columns.structure is like this:id (serial), object_id (int8), first_id (int8), second_id (int8), counter (int8)id is primary key,(object_id, first_id, second_id) form together unique index. i partitioned it using first_id and second_id as check params.works.but!when