BUG #14864: PostgresSQL script is skipping to process random records

From: bharti(dot)bhandari(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Cc: bharti(dot)bhandari(at)gmail(dot)com
Subject: BUG #14864: PostgresSQL script is skipping to process random records
Date: 2017-10-20 13:18:10
Message-ID: 20171020131810.1486.38392@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14864
Logged by: bharti bhandari
Email address: bharti(dot)bhandari(at)gmail(dot)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.

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Dunstan 2017-10-20 13:49:13 Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much
Previous Message Magnus Hagander 2017-10-20 08:57:06 Re: pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI