RE: [PEAR-DEV] MDB transactions in pgsql driver

> From: Jeroen Houben [mailto:jeroen@terena.nl] > Sent: Monday, June 02, 2003 4:42 PM > 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. > > > > 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. Hmm it should work with two columns .. just not with less. So when you add a third column it works? Regards, Lukas