btw, I don'jt hink that you want 'main.User'. You want 'public.user'
unless you made a Postgres (internal to the database)schema named
'main'.
On Jan 24, 5:56 pm, webasker <webas...@gmail.com> 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 symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en.
