5
100%
master: 100%

Ran 06 Aug 2019 07:58PM UTC

Files 25

Run time 3s

Badge

Embed ▾

Committed 06 Aug 2019 07:56PM UTC coverage: 100.0%. Remained the same

Job # DB=pgsql POSTGRESQL_VERSION=9.5 COVERAGE=yes

Build Type

push

travis-ci

Committed by

lazeevv

Commit Message

Added support deleting UNIQUE partial indexes (#22)

Added support for deleting unique indexes with WHERE conditions.

By default, if the created unique index contains no conditions, PostgresSQL automatically creates a Constraint for it, for example:

CREATE UNIQUE INDEX CONCURRENTLY examples_new_col_idx ON examples (new_col);
ALTER TABLE examples
    ADD CONSTRAINT examples_unique_constraint USING INDEX examples_new_col_idx;
If the unique index contains WHERE conditions, then such a Constraint will not be created, because PostgreSQL doesn't
define a partial (ie conditional) UNIQUE constraint.

When trying to delete such a partial unique index, we get the error "Unique Constraint not found", so the standard command to remove $table->dropUnique() does not fit, the command $table->dropIndex() is suitable, but if pass the array there, then the index name will be generated as for a regular index with the suffix _index, instead of _unique, which we need.

And manually generating the index name is wrong.

This Merge Request solves these problems.

Run Details

253 of 253 relevant lines covered (100.0%)

10.08 hits per line

umbrellio / laravel-pg-extensions / 305 / 5
100%
master: 100%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 305.5 (DB=pgsql POSTGRESQL_VERSION=9.5 COVERAGE=yes)

umbrellio / laravel-pg-extensions / 305 / 5 100% master: 100%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 305.5 (DB=pgsql POSTGRESQL_VERSION=9.5 COVERAGE=yes)

umbrellio / laravel-pg-extensions / 305 / 5
100%
master: 100%

README BADGES
x