philpeble-update-old-migrations-for-json-type-flexibility Allow postgres 9.4 and lower compatibility for CREATE INDEX …

There are several migrations that use the syntax 'CREATE INDEX
CONCURRENTLY IF NOT EXISTS'. Unfortunately the 'IF NOT EXISTS'
portion is only available in postgres 9.5 and higher. In order
to maintain compatibility with older versions these migrations
will omit that portion if necessary.

This is a slight behavior change that will result in a failure
if a conflict is detected.

Phil Peble avatar Phil Peble

Push event #1193.1 passed

  • Ran for
AMD64
no language set
Git
language: ruby
sudo: false

services:
  - postgresql

addons:
  postgresql: "9.6"

cache:
  directories:
    - vendor/bundle

rvm: "2.5.1"

env:
  - RAILS_ENV=test

script:
  - bundle exec rspec spec
  - script/validate_structure_file.rb db/main/structure-original.sql

before_script:
  - cp db/main/structure.sql db/main/structure-original.sql
  - cp config/database.yml.travis config/database.yml

after_success:
  - script/upload_structure.rb
Build Config
{
  "os": [
    "linux"
  ],
  "env": {
    "matrix": [
      "RAILS_ENV=test"
    ]
  },
  "rvm": [
    "2.5.1"
  ],
  "dist": "trusty",
  "sudo": false,
  "cache": {
    "directories": [
      "vendor/bundle"
    ]
  },
  "addons": {
    "postgresql": "9.6"
  },
  "script": [
    "bundle exec rspec spec",
    "script/validate_structure_file.rb db/main/structure-original.sql"
  ],
  "language": "ruby",
  "services": [
    "postgresql"
  ],
  "after_success": [
    "script/upload_structure.rb"
  ],
  "before_script": [
    "cp db/main/structure.sql db/main/structure-original.sql",
    "cp config/database.yml.travis config/database.yml"
  ]
}