Ruby on Rails

Is there some magic that's required to have db/schema.rb contain
various execute() methods that exist in the migrations files?

For example, suppose in a migration I have the following:

### BEGIN
create_table 'foo' do |t|
  t.text :name, :null => false
end

execute "ALTER TABLE public.foo ADD CHECK(trim(name) = name AND
length(name) > 2)"
### END

Is there a way to preserve this extra DDL foo so that it's preserved
in db/schema.rb?  As is, the rake test framework is arguably broken
for PostgreSQL because the db/schema.rb is always recreated without
the other DDL required to make a functional schema for the
application.

Is that a fair assessment?

-sc