diff options
author | Christian Wesselhoeft <christian.wesselhoeft@gmail.com> | 2015-10-13 14:50:19 -0600 |
---|---|---|
committer | Christian Wesselhoeft <christian.wesselhoeft@gmail.com> | 2015-10-13 14:50:19 -0600 |
commit | 0d34b550a491dab2ab58168c328907accdee6781 (patch) | |
tree | 8a01227f8c77333f1a4ed5665d0e302780e664c1 | |
parent | 9d05430c956c4ae1d0aefda02def5052ea818433 (diff) | |
download | rails-0d34b550a491dab2ab58168c328907accdee6781.tar.gz rails-0d34b550a491dab2ab58168c328907accdee6781.tar.bz2 rails-0d34b550a491dab2ab58168c328907accdee6781.zip |
Fix formatting of ActiveRecord PostgreSQL guide.
-rw-r--r-- | guides/source/active_record_postgresql.md | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/guides/source/active_record_postgresql.md b/guides/source/active_record_postgresql.md index f71e6ccd57..742db7be32 100644 --- a/guides/source/active_record_postgresql.md +++ b/guides/source/active_record_postgresql.md @@ -85,7 +85,7 @@ Book.where("array_length(ratings, 1) >= 3") * [type definition](http://www.postgresql.org/docs/current/static/hstore.html) -NOTE: you need to enable the `hstore` extension to use hstore. +NOTE: You need to enable the `hstore` extension to use hstore. ```ruby # db/migrate/20131009135255_create_profiles.rb @@ -252,6 +252,7 @@ article.save! ``` To add a new value before/after existing one you should use [ALTER TYPE](http://www.postgresql.org/docs/current/static/sql-altertype.html): + ```ruby # db/migrate/20150720144913_add_new_state_to_articles.rb # NOTE: ALTER TYPE ... ADD VALUE cannot be executed inside of a transaction block so here we are using disable_ddl_transaction! @@ -264,9 +265,10 @@ def up end ``` -NOTE: by now we can't drop ENUM values. You can read why [here](http://www.postgresql.org/message-id/29F36C7C98AB09499B1A209D48EAA615B7653DBC8A@mail2a.alliedtesting.com). +NOTE: ENUM values can't be dropped currently. You can read why [here](http://www.postgresql.org/message-id/29F36C7C98AB09499B1A209D48EAA615B7653DBC8A@mail2a.alliedtesting.com). Hint: to show all the values of the all enums you have, you should call this query in `bin/rails db` or `psql` console: + ```sql SELECT n.nspname AS enum_schema, t.typname AS enum_name, @@ -282,7 +284,7 @@ SELECT n.nspname AS enum_schema, * [pgcrypto generator function](http://www.postgresql.org/docs/current/static/pgcrypto.html#AEN159361) * [uuid-ossp generator functions](http://www.postgresql.org/docs/current/static/uuid-ossp.html) -NOTE: you need to enable the `pgcrypto` (only PostgreSQL >= 9.4) or `uuid-ossp` +NOTE: You need to enable the `pgcrypto` (only PostgreSQL >= 9.4) or `uuid-ossp` extension to use uuid. ```ruby @@ -397,7 +399,7 @@ A point is casted to an array containing `x` and `y` coordinates. UUID Primary Keys ----------------- -NOTE: you need to enable the `pgcrypto` (only PostgreSQL >= 9.4) or `uuid-ossp` +NOTE: You need to enable the `pgcrypto` (only PostgreSQL >= 9.4) or `uuid-ossp` extension to generate random UUIDs. ```ruby |