From 2a129380e82c81caaf02a099f01d319f0d54a7ab Mon Sep 17 00:00:00 2001
From: Fumiaki MATSUSHIMA <mtsmfm@gmail.com>
Date: Sun, 13 Dec 2015 12:46:59 +0900
Subject: Use `SET CONSTRAINTS` for `disable_referential_integrity` without
 superuser privileges (take 2)

Re-create https://github.com/rails/rails/pull/21233

eeac6151a5 was reverted (127509c071b4) because it breaks tests.

----------------

ref: 72c1557254

- We must use `authors` fixture with `author_addresses` because of its foreign key constraint.
- Tests require PostgreSQL >= 9.4.2 because it had a bug about `ALTER CONSTRAINTS` and fixed in 9.4.2.
---
 .travis.yml | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to '.travis.yml')

diff --git a/.travis.yml b/.travis.yml
index ad9ef4161d..ed4e0fba3b 100644
--- a/.travis.yml
+++ b/.travis.yml
@@ -15,6 +15,9 @@ services:
 
 addons:
   postgresql: "9.4"
+  apt:
+    packages:
+      - postgresql-9.4
 
 bundler_args: --without test --jobs 3 --retry 3
 before_install:
@@ -101,6 +104,12 @@ matrix:
       jdk: oraclejdk8
       env:
         - "GEM=am,amo,aj"
+    # Test with old (< 9.4.2) postgresql
+    - rvm: 2.4.0
+      env:
+        - "GEM=ar:postgresql"
+      addons:
+        postgresql: "9.4"
   allow_failures:
     - rvm: ruby-head
     - rvm: jruby-9.1.8.0
-- 
cgit v1.2.3