Hi all;
I'm migrating an application from MySQL to PostgreSQL and I'm hitting cases
where my lengthy model names are triggering index names that are too long
for PostgreSQL:
-- add_index("document_other_related_instruments", ["document_id"],
{:name=>"index_document_other_related_instruments_on_document_id"})
-> 0.0019s
-- add_index("document_other_related_instruments",
["other_related_instrument_id"], {:name=>"
index_document_other_related_instruments_on_other_related_instru"})
rake aborted!
Index name
'index_document_other_related_instruments_on_other_related_instru' on table
'document_other_related_instruments' is too long; the limit is 63 characters
The generated index name is being truncated at 64 characters long instead
of 63 - perhaps Hobo is missing the truncation by one character? I will
investigate for a bug.
If it's not a bug, can anyone tell me how to override the hobo-generated
index name? I can see how to do it within a Rails migration, but I don't
see any reference to controlling the migrations that Hobo generates in the
Hobo Manual, and this
thread<https://groups.google.com/d/topic/hobousers/CzVCrHNkXoA/discussion>hasn't
had any followup since 2009.
Many thanks,
Tim
--
You received this message because you are subscribed to the Google Groups "Hobo
Users" 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].
Visit this group at http://groups.google.com/group/hobousers.
For more options, visit https://groups.google.com/groups/opt_out.
