I am moving towards a partitioned schema. I use a function to insert into the table. If the INSERT fails because of duplicates I do an UPDATE. This works fine currently on the non-partitioned table because I can use GET DIAGNOSTICS to get the row count on the INSERT. But when I use the Master table to insert into the partitions, GET DIAGNOSTICS always returns 0. So there is no way of knowing whether a row was inserted (I am catching the unique violation exception to do the UPDATE). What is a good alternative? We are on 9.4, so the UPSERT is not yet available to me. There should be some way to know if data was inserted into the partition. Thanks RV -- View this message in context: http://postgresql.nabble.com/Inserting-into-a-master-table-with-partitions-does-not-return-rows-affected-tp5902708.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
