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:39:35
Message-ID: D1109E8B2FB53A45BDB60F8145905CE903A44242@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?

[Sorry, re-send as plain text. Mail client defaults to HTML]

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sébastien Lardière 2009-09-07 08:09:53 Re: [Skytools-users] WAL Shipping + checkpoint
Previous Message Ow Mun Heng 2009-09-07 07:38:33 trigger and returning the #of rows affected (partitioning)