trigger and returning the #of rows affected (partitioning)

From: "Ow Mun Heng" <ow(dot)mun(dot)heng(at)wdc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: trigger and returning the #of rows affected (partitioning)
Date: 2009-09-07 07:38:33
Message-ID: D1109E8B2FB53A45BDB60F8145905CE903A4423C@wdmyexbe03.my.asia.wdc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there any way in which a trigger can return the # of rows affected by the
insert / delete ?

Master

--> slave_1

--> slave_2

Trigger is against master which will, based on the conditions re-direct the
data into the relevant slave_X partitions.

I think this post basically is what I am seeing.

http://www.nabble.com/affected-rows-count-td21124000.html

If there any methods in which I can get back the affected # or rows
affected? Or will I have to use / do another trigger on the slave_X tables
to do the counts?

Browse pgsql-general by date

  From Date Subject
Next Message Ow Mun Heng 2009-09-07 07:39:35 trigger and returning the #of rows affected (partitioning)
Previous Message Guillaume Lelarge 2009-09-07 06:31:05 Re: edit function