Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-840

[GH-546] [DBAL-474] Fix filtering sequence names on PostgreSQL

    Details

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

      Description

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

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

      Message:

      The PostgreSQL schema manager has to filter sequence names before actually creating `Sequence` objects to avoid errors on accessing sequence database objects where the user has not enough privileges for.
      The reason for this is that retrieving sequence attributes other than the sequence name requires accessing the particular sequence database object directly which requires the connected user to have enough privileges. This might not always be the case if for example a particular user can only access certain schemas but not others.
      This patch might not be the best solution but a good compromise IMO. Changing the `AbstractSchemaManager` to filter sequence names before creating `Sequence` objects might affect other platforms and could also perhaps break BC. Furthermore this issue is completely PostgreSQL specific as it is the only currently supported platform not having a sequence's attributes stored directly in the system catalogs (AFAIK).

        Activity

        Hide
        Doctrine Bot added a comment -

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

        Show
        Doctrine Bot added a comment - A related Github Pull-Request [GH-546] was closed: https://github.com/doctrine/dbal/pull/546
        Show
        Marco Pivetta added a comment - Merged: https://github.com/doctrine/dbal/commit/6252da0cf1ed04cc790af533f0841bf5c01de44e

          People

          • Assignee:
            Marco Pivetta
            Reporter:
            Doctrine Bot
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: