We're updating the issue view to help you get more done. 

SequenceInformationExtractor does not take into account the schema indicated in ExtractionContext on PostreSQL

Description

When asking for the sequences located on schema "toto" I end up with those stored in all schemas.

Among other things the consequence is that the SchemaMigrator (my actual use case) create the sequences only on one schema (because when initializing other schemas the sequence "already exist"). It's also because the schema migrator totally ignore the schema name from the SequenceInformation but it does not make much sense to me that it end up with sequences from other schemas when asking for them in the first place anyway.

Environment

PostgreSQL10Dialect, PostgreSQL 11.4 on Ubuntu 19.0.4.1 (but also reproduced on various PostgreSQL versions and other systems)

Status

Assignee

Unassigned

Reporter

Thomas Mortagne

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

5.4.3

Priority

Major