PostgreSQL: support multiline default values. Closes #7533.

git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7801 5ecf4fe2-1ee6-0310-87b1-e25e094e27de

2 files changed, 8 insertions, 1 deletions

diff --git a/activerecord/test/defaults_test.rb b/activerecord/test/defaults_test.rb
index 39dcc82b49..965dd956b0 100644
--- a/activerecord/test/defaults_test.rb
+++ b/activerecord/test/defaults_test.rb
@@ -57,4 +57,10 @@ class DefaultTest < Test::Unit::TestCase
       assert_equal BigDecimal.new("2.78"), default.decimal_number
     end
   end
+
+  if current_adapter?(:PostgreSQLAdapter)
+    def test_multiline_default_text
+      assert_equal "--- []\n\n", Default.columns_hash['multiline_default'].default
+    end
+  end
 end
diff --git a/activerecord/test/fixtures/db_definitions/postgresql.sql b/activerecord/test/fixtures/db_definitions/postgresql.sql
index 3b929e338c..5e38978e21 100644
--- a/activerecord/test/fixtures/db_definitions/postgresql.sql
+++ b/activerecord/test/fixtures/db_definitions/postgresql.sql
@@ -109,7 +109,8 @@ CREATE TABLE defaults (
     char3 text default 'a text field',
     positive_integer integer default 1,
     negative_integer integer default -1,
-    decimal_number decimal(3,2) default 2.78
+    decimal_number decimal(3,2) default 2.78,
+    multiline_default text DEFAULT E'--- []\n\n'::text
 );
 
 CREATE TABLE auto_id_tests (