I had this problem once, hmmmm. As best as I can remember, I created the table using a BIG SERIAL column type with no starting or incrementing values (i.e. default ones), and it all worked when I did the process you've done.
I always start from the database and work to the application. I might try generating a doctrine schema first and see how well I can do that. Try using the BIG SERIAL. On Jan 24, 5:56 pm, webasker <[email protected]> wrote: > The database is created from PostGreSQL export and doctrine:build- > schema is used to generate the schema.yml file, then doctrine:build- > model to generate the model class. Here's the code for insert. > > $obj = new User(); > $obj->set('name', 'test'); > $obj->save(); > > I even tried specifying the schema name in the model class. > > $this->setTableName('main.User'); > > and the error becomes: > > sequence main."User_Id_seq" does not exist > stack trace > > * at () > in SF_SYMFONY_LIB_DIR\plugins\sfDoctrinePlugin\lib\vendor > \doctrine\Doctrine\Sequence\Pgsql.php line 60 ... > 57. > 58. return $this->nextId($seqName, > false); > 59. } else { > 60. throw new Doctrine_Sequence_Exception > ('sequence ' .$seqName . ' does not exist'); > 61. } > 62. } > > But this sequence does exist in the database, I don't know why > Doctrine is not recognizing it. Anyone have any ideas? > > Thanks. -- You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en.
