how to find the number of rows inserted into the master table?

From: SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to find the number of rows inserted into the master table?
Date: 2007-09-05 14:27:36
Message-ID: 451879.68751.qm@web31103.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I have a master table 'Master' with 3 partition tables 'child1', 'child2',' child3' which inherits the master table 'Master'. I have check constraints in the child tables to insert the appropriate values and also there are functions and triggers defined to do this.
My question is, if I insert a row into master, the row correctly gets inserted into the child tables. But the output always shows '0 rows inserted' since the rows are not actually inserted in to the master.
Is there a way to show the number of rows inserted into the master tables (though in reality the rows get inserted into the partitions and not the master)

Thanks in advance
shar joe

---------------------------------
Pinpoint customers who are looking for what you sell.

Browse pgsql-general by date

  From Date Subject
Next Message Owen Hartnett 2007-09-05 14:35:15 Re: problem with transactions in VB.NET using npgsql
Previous Message SHARMILA JOTHIRAJAH 2007-09-05 14:23:47 how to find the number of rows inserted into the master table?