Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

BUG #3993: RULE UPDATE : GET DIAGNOSTICS ROW_COUNT = 0



The following bug has been logged online:

Bug reference:      3993
Logged by:          vasile
Email address:      vasile(dot)halosta(at)gmail(dot)com
PostgreSQL version: 8.2.4
Operating system:   Centos 5
Description:        RULE UPDATE : GET DIAGNOSTICS ROW_COUNT = 0
Details: 

I have create 2 partitions for table tbl using inheritance and rules. 

Before having partitions on table tbl, I was using GET DIAGNOSTICS ROW_COUNT
to check the number of rows updated/inserted. 

After creating partitions on tbl when I run UPDATE/INSERT on the master
table (tbl) the ROW_COUNT is 0. 

It may be correctly the ROW_COUNT to be 0 because the rows was
inserted/updated in another table (in partitions) and not in master table. 

Please help me to find a solution to retrieve the number of rows
inserted/updated in all table partitions. 


Thank You,
Vasile.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group