Hello, So I'm adding a Postgres Enum Type with a migration but I'm having a
problem with db/schema.rb output breaking when I do this:
def up
execute <<-SQL.squish
CREATE TYPE three_letters_type AS ENUM (
'A',
'B',
'C',
);
SQL
execute <<-SQL.squish
ALTER TABLE test
ADD COLUMN three_letters three_letters_type;
SQL
end
I end up with the following comments in db/schema.rb -
# Could not dump table "test" because of following StandardError
# Unknown type 'three_letters_type' for column 'three_letters'
It's quite important for me to be able to use Enums because unique-indexes
across several columns are expensive and it's highly preferable not to use
t.string (varchar) here. Would be great to hear if there is a work-around
for this, thanks.
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/67983333-042c-4437-8fc5-edeb06fa0300%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
