Uploaded image for project: 'Doctrine DBAL'
  1. Doctrine DBAL
  2. DBAL-474

SchemaManager / Connection on PostgreSQL platform does not respect filterExpression for sequences


    • Type: Bug
    • Status: In Progress
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.2.2
    • Fix Version/s: None
    • Component/s: Schema Managers
    • Security Level: All
    • Environment:
      Windows & Linux


      Dear Symfony team,

      the filterExpression on AbstractSchemaManager seems not to work for sequences.

      This only happens under postgres.

      It seems the way the sequences are handled are the culprit: It tries to get min_value etc of sequences without matching sequence names to the filter expression in advance.

      If for example access to the sequences is denied, (Different schema without permissions for the current entity manager), any higher-level ORM operations like generating migration versions fail.

      --------------------- UPDATE

      the context is when using migrations. Positive regexp expressions do not limit the migration to a single schema. eg ^schemaname.$
      Instead, all sequences on the current database are returned.
      When trying to limit a migration to a single schema consecutively this doesn't work.
      We are using a per-schema connection, so this results in a lot of hassle for us.



          • Assignee:
            deeky666 Steve Müller
            josdewitte jos de witte
          • Votes:
            1 Vote for this issue
            6 Start watching this issue


            • Created: