Re: [GENERAL] PHP PDO-PGSQL and transactions

2008-12-01 Thread Raymond C. Rodgers
Martijn van Oosterhout wrote: On Mon, Dec 01, 2008 at 10:14:52AM +0100, Bart Degryse wrote: I'm having a transaction problem when executing prepared statements using the PHP PDO-PGSQL module. What happens is this: On the first $subItem, $checkSubscription goes well, but $insertReminderEntry

Re: [GENERAL] PHP PDO-PGSQL and transactions

2008-12-01 Thread Bart Degryse
Thanks Martijn! >>> Martijn van Oosterhout <[EMAIL PROTECTED]> 2008-12-01 10:54 >>> On Mon, Dec 01, 2008 at 10:14:52AM +0100, Bart Degryse wrote: > I'm having a transaction problem when executing prepared statements using the > PHP PDO-PGSQL module. > What happens is this: > On the first $subItem

Re: [GENERAL] PHP PDO-PGSQL and transactions

2008-12-01 Thread Martijn van Oosterhout
On Mon, Dec 01, 2008 at 10:14:52AM +0100, Bart Degryse wrote: > I'm having a transaction problem when executing prepared statements using the > PHP PDO-PGSQL module. > What happens is this: > On the first $subItem, $checkSubscription goes well, but $insertReminderEntry > fails with error > "Dupli

[GENERAL] PHP PDO-PGSQL and transactions

2008-12-01 Thread Bart Degryse
I'm having a transaction problem when executing prepared statements using the PHP PDO-PGSQL module. What happens is this: On the first $subItem, $checkSubscription goes well, but $insertReminderEntry fails with error "Duplicate key violates unique constraint" This error should just be logged and