Doctrine 1
  1. Doctrine 1
  2. DC-791

[PostgreSQL] In case model is build from existing database sequence name is invalid and doctrine throw exception

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Blocker Blocker
    • Resolution: Unresolved
    • Affects Version/s: 1.2.2
    • Fix Version/s: None
    • Component/s: Schema Files
    • Labels:
      None
    • Environment:
      symfony 1.4.5, postgresql 8.4, debian lenny, nginx

      Description

      Firstly I created database directly in postgresql.
      After that I generated schema from existsing database and after all i built model.

      When I try to insert new record to database I received following error:

      sequence "Category_id_seq" does not exist

      In schema file sequence name is defined like this: sequence: '"Address_id_seq"'
      There's are apostrophes and quotes.

      In Category model file is same like above, apostrophes and quotes.

      When I remove quotes from sequence in model files everything is ok and there're no problems with insert new row to database.

        Activity

        Przemysław Ciąćka created issue -
        Jonathan H. Wage made changes -
        Field Original Value New Value
        Fix Version/s 1.2.4 [ 10063 ]
        Fix Version/s 1.2.3 [ 10051 ]
        Guilherme Blanco made changes -
        Fix Version/s 1.2.4 [ 10063 ]

          People

          • Assignee:
            Jonathan H. Wage
            Reporter:
            Przemysław Ciąćka
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: