Edit report at http://pear.php.net/bugs/bug.php?id=16261&edit=1

ID: 16261
Updated by: daniel.oconnor@gmail.com
Reported By: mack at ifis dot cs dot tu-bs dot de
Summary: Sequences do not get created in postgresql
-Status: Open
+Status: Duplicate
Type: Bug
Package: MDB2
Operating System: Linux 2.6.22 x86_64OpenSUSE 10.3
Package Version: 2.4.1
PHP Version: 5.2.5
Roadmap Versions:
New Comment:

-Status: Open
+Status: Duplicate

Previous Comments:

[2009-05-25 09:01:35] #126fa6015f36fb64dee

Actually, I have PHP version 5.2.6 and not 5.2.5. It came with XAMPP of
September 2008 or similar.

Sequences do not get created on nextID() in pear/MDB2/Driver/pgsql.php,
when the sequence does not yet exist.

Reason: the result code of 'SELECT NEXTVAL('seqence_name') is checked
for MDB2_ERROR_NOSUCHTABLE, but the return value of queryOne() in
MDB2.php is MDB2_ERROR instead.

This can be tracked down to pg_query returning nothing in function
&_doQuery(...) in file pear/MDB2/Driver/pgsql.php .

See Bug 13366 for probably the same error in the outdated DB package.

WORKAROUND: check for MDB2_ERROR as well.


Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppear-bugs @
postedMay 26, '09 at 1:22p
activeMay 26, '09 at 1:22p

1 user in discussion

Daniel Oconnor: 1 post



site design / logo © 2021 Grokbase