Re: MDB transactions in pgsql driver

Lukas Smith wrote:

From: Jeroen Houben [mailto:jeroen@terena.nl] Sent: Monday, June 02, 2003 2:05 PM Lukas Smith wrote:

From: Jeroen Houben [mailto:jeroen@terena.nl] Sent: Wednesday, May 28, 2003 1:47 PM

So the errors you were receiving happend in this code fragment?

Yes. in: $groups = $db->getAssoc('SELECT group_id, name FROM groups');

Do you have autofree on or off?

Using Mdb 1.1.3RCI I set it to "on" and one error disappeared but I still have : Notice: Undefined index: Coordinators in /usr/local/share/php/pear/MDB/pgsql.php on line 1267 Warning: pg_numrows(): supplied argument is not a valid PostgreSQL result resource in /usr/local/share/php/pear/MDB/pgsql.php on line 799

hmm I am having trouble reproducing this error. Therefore I would like you to do the following things for me: 1) run the test suite and set autofree to true in the test_setup.php 2) run MDB_test.php?db_type=pgsql (this script is also available in the test dir) I can't reproduce this error using the above tests. If the errors don't occur with these tests you will have to send me a larger piece of code with which I can reproduce these errors. If the errors do occur in the tests then please send me the output. Hi Lukas, The tests ran fine. I've found the problem though. Things go wrong when I use a table with only 2 columns. I thought it was possible to use getAssoc with 2 cols, just like in DB (http://pear.php.net/manual/en/package.database.db.db-common.getassoc.php). But it either isn't or this is a bug after all. I'm pretty sure it worked in older versions of MDB. Thanks for your quick replies. HTH Jeroen