There are more changes that need to be made in the Table::insert() method to support other cases. Sequences and tables with natural keys need to be supported. I have posted a couple of times to the fw-db list about some thoughts regarding this, but so far I have been too busy to post an actual proposal.
Regards, Bill Karwin > -----Original Message----- > From: Kevin McArthur [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 22, 2007 2:31 PM > To: Teemu Välimäki; fw-general@lists.zend.com > Subject: Re: [fw-general] Bug in Table/Abstract and more > > Ya I noticed the sequence issues, but running 8.1 the defaults (now 0.9.0) > work right. > > I wonder, is there a way to set the sequence name and if not maybe there > should be... > > K > ----- Original Message ----- > From: "Teemu Välimäki" <[EMAIL PROTECTED]> > To: <fw-general@lists.zend.com> > Sent: Thursday, March 22, 2007 1:29 PM > Subject: [fw-general] Bug in Table/Abstract and more > > > > Hi, > > > > with 22 day snapshot Db/Table/Abstract.php on line 399 "return > > $this->_db->lastInsertId();" should apparently give $this->_name as a > > parameter, otherwise the call will always fail. lastInsertId has a > > $tableName = null and the first thing is if (!$tableName) throw. After I > > fixed line 399 with $this->_name I got sequence does not exists error. > > > > On Db/Adapter/Pdo/Pgsql.php on line 202 there's a huge assumption how > the > > sequence is formed. With 8.2 auto generated sequences are named like > > "{$tableName}_{$tableName}_{$primaryKey}_seq". > > > > After fixing these all seem to work well. I'm not sure if this automatic > > sequence creation is defined in Postgresql configurations but this has > > been the setup on FreeBSD 6.2 and *buntu 6.10. > > > > Cheers!