Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-389

[GH-232] Problem with sequence names, PostgreSQL and MixedCased schemas

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.4
    • Component/s: None
    • Security Level: All
    • Labels:
      None

      Description

      This issue is created automatically through a Github pull request on behalf of ajgarlag:

      Url: https://github.com/doctrine/dbal/pull/232

      Message:

      I''m having problems with a doctrine migration in a pgsql database that has a mixed case schema name.

      After some investigation I've found the origin of the problem: when the schema manager is going to list sequences it executes a SQL statement to find the minimun sequence value.

      This SQL statement is not quoting the sequence name, so the SQL fails with mixed cased schemas.

      This trivial commit resolves this problem. I think it could be backported to stable versions of DBAL.

        Activity

        Benjamin Eberlei created issue -
        Hide
        Benjamin Eberlei added a comment -

        A related Github Pull-Request [GH-232] was closed
        https://github.com/doctrine/dbal/pull/232

        Show
        Benjamin Eberlei added a comment - A related Github Pull-Request [GH-232] was closed https://github.com/doctrine/dbal/pull/232
        Marco Pivetta made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Benjamin Eberlei made changes -
        Fix Version/s 2.4 [ 10320 ]

        This list may be incomplete, as errors occurred whilst retrieving source from linked applications:

        • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DBAL-389, expand=changesets[0:20].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Benjamin Eberlei
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: