# Error in dropIndex in Postgres 9.4

**URL:** <https://forum.liquibase.org/t/error-in-dropindex-in-postgres-9-4/3276>\
**Category:** General Discussion\
**Created:** [September 8, 2015, 11:34pm UTC](https://forum.liquibase.org/t/error-in-dropindex-in-postgres-9-4/3276 "2015-09-08T23:34:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![CarlosCruz](https://avatars.discourse-cdn.com/v4/letter/c/53a042/32.png) [@CarlosCruz](https://forum.liquibase.org/u/CarlosCruz)\
**Post date:** [September 8, 2015, 11:34pm UTC](https://forum.liquibase.org/t/error-in-dropindex-in-postgres-9-4/3276/1 "2015-09-08T23:34:00Z")

</div>

Actually I am working with Liquibase 3.3.2 and Postgres 9.4 and I want  
to upgrade it to 3.4.1. So I started my tests and I found a problem:  
When I have a changeset like this:

  
  

 

```
  <rollback>

       <createIndex indexName="idx_name"

```

schemaName=“my\_schema” tableName=“my\_table” unique=“false”\>

In  
liquibase 3.3.2 there is no problem, but with liquibase 3.4.1. I got  
an org.postgresql.util.PSQLException and says that the index  
doesn’t exist. I have saved both sql statements in a file and this  
is the result:

  

Liquibase 3.3.2:

  

DROP INDEX my\_schema.idx\_name;  

Liquibase 3.4.1:

  

DROP INDEX idx\_name;  

So, I see that the newest version doesn't add the schema name to the sentence.

  

This is how the index was created in a previous changeset:

  

  

 

```
      <column name="my_column"/>

  </createIndex>

```

  

  

Thanks a lot !!