As I was searching for my problem below, I read that the sequences are only supported in some of the rdbms such as oracle and pgsql. I am disappointed since I was expecting an implementation like PEAR MDB2 and other db abstraction layers.
As a result, if we are using MySQL then we will not be able to use sequences. Or we have to use PgSQL, Oracle or something else. Am I right? :s scs On Sun, Oct 25, 2009 at 1:23 AM, scs <[email protected]> wrote: > Hi, > Is the model class code below enough to use sequence for this model/table? > Is there something extra that I shall do for getting the primary key > from sequence? > > class Default_Model_DbTable_Test extends Zend_Db_Table_Abstract > { > protected $_name = 'table_name'; > protected $_sequence = '_seq_table_name'; > > protected $_primary = 'id'; > protected $_pk = 'id'; > } > > If not, this code does not get a new id from defined sequence? > Any correction or idea? > > Thanks > scs >
