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 [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.


Reply via email to