On Mon, Dec 14, 2009 at 11:15 PM, Philip Graham <phi...@lightbox.org> wrote: > > The following bug has been logged online: > > Bug reference: 5244 > Logged by: Philip Graham > Email address: phi...@lightbox.org > PostgreSQL version: 8.3.8 > Operating system: Linux > Description: Attempting to rollback to a savepoint after receiving an > error with state 55000 the process hangs > Details: > > This may be a PHP so please excure me if it is. > > <?php > $pdo = new PDO('pgsql:host=localhost;dbname=a_db', 'a_user', 'my_pass'); > $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); > > echo 'Creating test objects'."\n"; > $pdo->query('CREATE SEQUENCE test_seq'); > > echo 'Setup complete'."\n"; > $pdo->beginTransaction(); > > try { > echo 'Setting savepoint'."\n"; > $pdo->query('SAVEPOINT pre_id_fetch'); > echo 'Fetching value'."\n"; > $stmt = $pdo->query('SELECT currval(\'test_seq\');'); > $curId = $stmt->fetchColumn(); > echo 'Releasing savepoint'."\n"; > $pdo->query('RELEASE SAVEPOINT pre_id_fetch'); > } catch (PDOException $e) { > echo 'Rolling back'."\n"; > $pdo->query('ROLLBACK TO pre_id_fetch'); > $curId = 0; > } > > echo 'Cur Id: ',$curId,"\n"; > > > Running this code it hangs after echoing 'Rolling back', but only hangs > every other execution (assuming the sequence was deleted first).
I can't reproduce this using psql. Could you try? I am guessing that PHP is doing something funky, but I'm not really sure what. I do notice that you don't seem to have an endTransaction() or similar to match the beginTransaction() - could that be relevant? ...Robert -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs