Partitioned tables do not return affected row counts to client

From: rverghese <riyav(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Partitioned tables do not return affected row counts to client
Date: 2016-06-02 18:01:36
Message-ID: 1464890496966-5906112.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We are looking to move from one large table to partitioned tables. Since the
inserts and updates are made to the master table and then inserted into the
appropriate partitioned table based on the trigger rules, the affected_rows
returned to the client (PHP in this case) is always 0. We have been using
the affected_rows to check various things on the client end. Is there an
alternative to check for rows affected with partitioned tables? Seems like a
pretty big missing feature.
Thanks
RV

--
View this message in context: http://postgresql.nabble.com/Partitioned-tables-do-not-return-affected-row-counts-to-client-tp5906112.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2016-06-02 20:07:55 Re: dumb question
Previous Message David G. Johnston 2016-06-02 17:58:47 Re: dumb question