Hmm... seems like an issue with the activerecord PostgreSQL adapter:
https://rails.lighthouseapp.com/projects/8994/tickets/6187-postgresql-and-rails-303-migrations-fail-with-index-name-length-64-chars
and I see that Hobo simply inquires about the max length from the model's
connection (in index_spec.rb):
if check_name.length > @model.connection.index_name_length
r += ", :name => '#{name[0,@model.connection.index_name_length]}'"
$stderr.puts("WARNING: index name #{check_name} too long,
trimming")
So, if this is the case, is there any way for me to intervene in the name
that HObo's migration generator comes up with?
Or, should Hobo be using index_name_length-1 ?
Tim
On Sunday, January 26, 2014 9:01:46 AM UTC-5, Tim Griffin wrote:
>
> 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.
