Postgresql INSERT triggers "0 row affected" workaround

Question

In a INSERT trigger based table partition, insert always give "0 row affected". I think this problem is well know, it is even in the todo.

Is there any workarounds for this issue in 9.4?

Answer 1

You can try to catch the number of inserted rows using GET DIAGNOSTICS and then raise a notice/warning/whatever you prefer. Here is a small illustration:

DO $$
    DECLARE cnt integer;
    BEGIN
        INSERT INTO b SELECT i FROM generate_series(1,9) t(i);
        GET DIAGNOSTICS cnt := ROW_COUNT;
        RAISE WARNING '% row(s) affected', cnt;
    END; 
$$;
-- gives:

WARNING:  9 row(s) affected
DO