How did you even create the table User? Did you quote any or all of the table/column names. I have Postgres 8.4 and it won't let me even create the user table unless I quote the table names (unfortuately, Doctrine seems to only allow quoting ALL table names AND ALL column names) Probably not much performance difference.
On Jan 21, 3:01 am, webasker <webas...@gmail.com> wrote: > Can someone please help me? > > I have a database with schema "main" that include a table "User". I > get this exception when inserting an entry into table User. > > Doctrine_Sequence_Exception > on demand sequence main."User_Id_seq" could not be created > at () > in SF_SYMFONY_LIB_DIR\plugins\sfDoctrinePlugin\lib\vendor\doctrine > \Doctrine\Sequence\Pgsql.php line 56 ... > > Here's my Doctrine schema.yml > > User: > tableName: User > columns: > id: > type: integer(4) > primary: true > sequence: 'main."User_Id_seq"' > name: > type: string(32) > notnull: true > > This is the generated model class. > > abstract class BaseUser extends sfDoctrineRecord > { > public function setTableDefinition() > { > $this->setTableName('User'); > $this->hasColumn('id', 'integer', 4, array( > 'type' => 'integer', > 'primary' => true, > 'sequence' => 'main."User_Id_seq"', > 'length' => '4', > )); > $this->hasColumn('name', 'string', 32, array( > 'type' => 'string', > 'notnull' => true, > 'length' => '32', > )); > } > > } > > Thanks so much. -- 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.