Postgres Pro
Downloads
Home   >   mailing lists

Re: Insert result does not match record count - Mailing list pgsql-general

From Tom Lane
Subject Re: Insert result does not match record count
Date
Msg-id 24380.1374275688@sss.pgh.pa.us
Whole thread Raw
In response to Insert result does not match record count  (Natalie Wenz <nataliewenz@ebureau.com>)
Responses Re: Insert result does not match record count
List pgsql-general
Tree view 
Natalie Wenz <nataliewenz@ebureau.com> writes:
> I am moving some data from one table to another in 9.2.4, and keep seeing this strange scenario:
> ...
> So, my counts from the old and new tables match, but the result returned from the insert statement is sometimes a
completelydifferent number. (But not always.) I've checked my date ranges very carefully to make sure they match.  

Perhaps you've got triggers or rules on the target table that are
suppressing some inserts?

            regards, tom lane

pgsql-general by date:

Previous
From: Natalie Wenz
Date:
Subject: Insert result does not match record count
Next
From: "guxiaobo1982"
Date:
Subject: Reply: Can we specify transaction level