[BUGS] BUG #14864: PostgresSQL script is skipping to process random records - Mailing list pgsql-bugs

From bharti.bhandari@gmail.com
Subject [BUGS] BUG #14864: PostgresSQL script is skipping to process random records
Date
Msg-id 20171020131810.1486.38392@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14864
Logged by:          bharti bhandari
Email address:      bharti.bhandari@gmail.com
PostgreSQL version: 9.4.10
Operating system:   Heroku Env
Description:

We are using salesforce heroku connection in our project. 
We have an object in Salesforce named  WorkRota ( It captures
resource/contact availability for a particular time period )  and our goal
was to split every workrota in 10 - 10 minutes slot. We store these 10-10
minutes slots in another table in Postgres named ContactAvailability and we
wrote a stored procedure for the conversion process.  

There is one more object from Salesforce to Heroku named Assignment is used
for making the contactavailality unavailable. 

The problem is when the records comes in bulk then  the script is skipping
random record. The behaviour is not frequent as well. 

Please let me know if any one can help. Happy come on GTM/ Call to explain
in detail. 




--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: [BUGS] pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI
Next
From: Andrew Dunstan
Date:
Subject: Re: [BUGS] BUG #14849: jsonb_build_object doesn't like VARIADIC callsvery much