aboutsummaryrefslogtreecommitdiffstats
path: root/guides/source/testing.md
diff options
context:
space:
mode:
authorandrey.nering@gmail.com <andrey.nering@gmail.com>2014-12-09 10:17:02 -0200
committerandrey.nering@gmail.com <andrey.nering@gmail.com>2014-12-09 13:36:10 -0200
commit6d59473b4873a81d7cc56023d17f8ec83075b803 (patch)
treebd1933952e093c797087e42ebe552a993c92d68b /guides/source/testing.md
parent8e52954349c29d5f190f01b21e9087885afd8dab (diff)
downloadrails-6d59473b4873a81d7cc56023d17f8ec83075b803.tar.gz
rails-6d59473b4873a81d7cc56023d17f8ec83075b803.tar.bz2
rails-6d59473b4873a81d7cc56023d17f8ec83075b803.zip
Adding a tip in the guides about possible database permission problems on
loading fixtures to the database. Reference #17542
Diffstat (limited to 'guides/source/testing.md')
-rw-r--r--guides/source/testing.md2
1 files changed, 2 insertions, 0 deletions
diff --git a/guides/source/testing.md b/guides/source/testing.md
index d54f431d54..40abac0507 100644
--- a/guides/source/testing.md
+++ b/guides/source/testing.md
@@ -122,6 +122,8 @@ Rails by default automatically loads all fixtures from the `test/fixtures` folde
* Load the fixture data into the table
* Dump the fixture data into a variable in case you want to access it directly
+TIP: In order to remove existing data from the database, Rails tries to disable referential integrity triggers (like foreign keys and check constraints). If you are getting annoying permission errors on running tests, make sure the database user has privilege to disable these triggers in testing environment. (In PostgreSQL, just superusers can disable all triggers. Read more about PostgreSQL permissions [here](http://blog.endpoint.com/2012/10/postgres-system-triggers-error.html))
+
#### Fixtures are Active Record objects
Fixtures are instances of Active Record. As mentioned in point #3 above, you can access the object directly because it is automatically setup as a local variable of the test case. For example: