FAQ
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

Description:
------------
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 @
categoriesphp
postedMay 26, '09 at 1:23p
activeMay 26, '09 at 1:23p
posts1
users1
websitepear.php.net

1 user in discussion

Daniel Oconnor: 1 post

People

Translate

site design / logo © 2021 Grokbase