Skip Menu |

This queue is for tickets about the CHI-Driver-DBI CPAN distribution.

Report information
The Basics
Id: 102761
Status: open
Priority: 0/
Queue: CHI-Driver-DBI

People
Owner: Nobody in particular
Requestors: JETEVE [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 1.27
Fixed in: (no value)



Subject: Cannot run on postgresql with RaiseError
Hi, I found a bug where running with Postgresql with RaiseError => 1 as the DBI Option, this cannot run. This is due to the fact that the code in CHI::Driver::DBI::store first try to do an INSERT and then an UPDATE. Doing an INSERT with an existing primary key will raise an exception (per DBI option RaiseError = 1), causing this store method to fail altogether with this setting. Thanks, Jerome.
On Sat Mar 14 10:56:26 2015, JETEVE wrote: Show quoted text
> Hi, > > I found a bug where running with Postgresql with RaiseError => 1 as > the DBI Option, this cannot run. > > This is due to the fact that the code in CHI::Driver::DBI::store first > try to do an INSERT and then an UPDATE. > > Doing an INSERT with an existing primary key will raise an exception > (per DBI option RaiseError = 1), causing this store method to fail > altogether with this setting.
This would be fixed by the PR https://github.com/jonswar/perl-chi-driver-dbi/pull/5 /J