1--TEST-- 2Bug #49985 (pdo_pgsql prepare() re-use previous aborted transaction) 3--EXTENSIONS-- 4pdo 5pdo_pgsql 6--SKIPIF-- 7<?php 8require __DIR__ . '/config.inc'; 9require __DIR__ . '/../../../ext/pdo/tests/pdo_test.inc'; 10PDOTest::skip(); 11?> 12--FILE-- 13<?php 14require __DIR__ . '/../../../ext/pdo/tests/pdo_test.inc'; 15$db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 16$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 17 18$db->exec("CREATE TABLE test (a int PRIMARY KEY)"); 19 20for ($i = 0; $i < 3; $i++) { 21 try { 22 $db->beginTransaction(); 23 $stmt = $db->prepare("INSERT INTO test (a) VALUES (?)"); 24 var_dump($stmt->execute(array(1))); 25 $db->commit(); 26 } catch (Exception $e) { 27 echo trim(current(explode("\n", $e->getMessage())))."\n"; 28 $db->rollback(); 29 } 30} 31 32?> 33--EXPECTF-- 34bool(true) 35SQLSTATE[23505]: %stest_pkey%s 36SQLSTATE[23505]: %stest_pkey%s 37