Hi Ignacio;
I have *document.rb:*
class Document < ActiveRecord::Base
hobo_model
...
# Other instruments referenced by this document
has_many :document_other_related_instruments, :accessible => true
has_many :other_related_instruments, :class_name => "Instrument",
:through => :document_other_related_instruments
end
and *document_other_related_instrument.rb*
class DocumentOtherRelatedInstrument < ActiveRecord::Base
hobo_model
...
belongs_to :document
belongs_to :other_related_instrument, :class_name => "Instrument"
...
end
Gives me:
-- 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
Tim
On Sun, Jan 26, 2014 at 12:37 PM, Ignacio Huerta <[email protected]>wrote:
> That's weird Tim,
>
> It certainly looks like a bug in Hobo, I believe
> @model.connection.index_name_length will return "63" with PostgreSQL, so
> Hobo should not try to create index names with 64 characters.
>
> Can you give me a bit more info about your model names/relationships so
> I can reproduce it with the closest example as possible?
>
> Warm regards,
> Ignacio
>
> El 26/01/14 15:11, Tim Griffin escribió:
> > 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.
>
> --
> Ignacio Huerta Arteche
> http://www.ihuerta.net
> Teléfono: 0034 645 70 77 35
> Email realizado con software libre
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Hobo Users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/hobousers/d7y2LydE1y8/unsubscribe.
> To unsubscribe from this group and all its topics, 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.
>
--
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.
