Worked on the doctrine/dbal repository to address schema-aware index drop handling for PostgreSQL databases. Focused on resolving a bug where dropping an index on a table in a non-default schema required the schema name to be correctly prefixed. Enhanced the robustness of the solution by expanding PHPUnit test coverage, introducing new tests to validate index operations across multiple schemas, and improving test infrastructure with helper methods for schema setup and teardown. Utilized PHP and SQL to ensure reliable schema management and database testing, reducing regression risk and supporting cleaner, more maintainable test environments for multi-schema PostgreSQL deployments.