public void shouldDropIndexInPostgreSQL() throws Exception {
DropIndexGenerator dropIndexGenerator = new DropIndexGenerator();
DropIndexStatement statement = new DropIndexStatement("indexName", "defaultCatalog", "defaultSchema", "aTable", null);
Database database = new PostgresDatabase();
SortedSet<SqlGenerator> sqlGenerators = new TreeSet<SqlGenerator>();
SqlGeneratorChain sqlGenerationChain = new SqlGeneratorChain(sqlGenerators);
Sql[] sqls = dropIndexGenerator.generateSql(statement, database, sqlGenerationChain);
assertEquals("DROP INDEX \"defaultSchema\".\"indexName\"", sqls[0].toSql());
statement = new DropIndexStatement("index_name", "default_catalog", "default_schema", "a_table", null);
sqls = dropIndexGenerator.generateSql(statement, database, sqlGenerationChain);