Re: [GENERAL] duplicate key errors in log file

2015-11-20 Thread Jim Nasby
On 11/18/15 2:42 PM, Jeff Janes wrote: But he already knows it has race conditions. That is why he included retry logic, to deal with those conditions. From the sounds of it there's no retry loop, which means there's still a race condition (data is deleted after insert fails but before update

Re: [GENERAL] duplicate key errors in log file

2015-11-18 Thread Jeff Janes
On Wed, Nov 18, 2015 at 9:35 AM, Jim Nasby wrote: > On 11/17/15 5:33 PM, anj patnaik wrote: >> >> The pg log files apparently log error lines every time a user inserts a >> duplicate. I implemented a composite primary key and then when I see the >> exception in my client app I update the row with

Re: [GENERAL] duplicate key errors in log file

2015-11-18 Thread Jim Nasby
On 11/17/15 5:33 PM, anj patnaik wrote: The pg log files apparently log error lines every time a user inserts a duplicate. I implemented a composite primary key and then when I see the exception in my client app I update the row with the recent data. however, I don't want the log file to fill ou

Re: [GENERAL] duplicate key errors in log file

2015-11-18 Thread Adrian Klaver
On 11/17/2015 03:33 PM, anj patnaik wrote: The pg log files apparently log error lines every time a user inserts a duplicate. I implemented a composite primary key and then when I see the exception in my client app I update the row with the recent data. however, I don't want the log file to fill

[GENERAL] duplicate key errors in log file

2015-11-18 Thread anj patnaik
The pg log files apparently log error lines every time a user inserts a duplicate. I implemented a composite primary key and then when I see the exception in my client app I update the row with the recent data. however, I don't want the log file to fill out with these error messages since it's han