On 31 October 2016 at 14:41, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote: > On 10/31/2016 02:06 AM, Kiran wrote: >> I know 94 = 1 + (3 * 31). >> I am just having a normal insert statement into cf_question table. > > Are there any other triggers on the tables? I'm fairly confident that the duplicates are from updates on the cf_question table. Since the trigger also fires on update and then inserts another record, that would explain the duplication pretty well. Nevertheless, if there are other triggers those bear investigation. -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general