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

ID: 16260
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: Feedback
Type: Bug
Package: MDB2
Operating System: Linux 2.6.22 x86_64OpenSUSE 10.3
PHP Version: 5.2.5
Roadmap Versions:
New Comment:

-Status: Open
+Status: Feedback

We are unable to reproduce the bug as reported.
Please provide a simple script (10 lines or less)
or a link to an external script that can be used
to reproduce the bug.

If you can provide the script, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PEAR.

Unless you've got a reproduce script, this is either a bogus/duplicate
of Bug #13366

Previous Comments:

[2009-05-25 08:39:45] #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:23p
activeMay 26, '09 at 1:23p

1 user in discussion

Daniel Oconnor: 1 post



site design / logo © 2021 Grokbase