From 4eb7d82ae7b085049a889b8f4e7d421f05b39d07 Mon Sep 17 00:00:00 2001 From: Andrey Kumanyaev Date: Wed, 10 Oct 2012 03:31:51 +0400 Subject: [PATCH] add support use string FK with integer PK --- db/migrate/20121009205010_postgres_create_integer_cast.rb | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 db/migrate/20121009205010_postgres_create_integer_cast.rb diff --git a/db/migrate/20121009205010_postgres_create_integer_cast.rb b/db/migrate/20121009205010_postgres_create_integer_cast.rb new file mode 100644 index 000000000..b9a971387 --- /dev/null +++ b/db/migrate/20121009205010_postgres_create_integer_cast.rb @@ -0,0 +1,15 @@ +class PostgresCreateIntegerCast < ActiveRecord::Migration + def up + execute <<-SQL + CREATE CAST (integer AS text) WITH INOUT AS IMPLICIT; + SQL + rescue ActiveRecord::StatementInvalid + end + + def down + execute <<-SQL + DROP CAST (integer AS text); + SQL + rescue ActiveRecord::StatementInvalid + end +end -- 2.11.0