I haven''t seen anyone mention this yet. The tail end of the migration process is a call to schema.dump. Our primary keys are uuids and these choke schema.dump on both oracle and postgres. The latter fails silently (skips three tables) while the former complains about the RAW(16) in each of the three tables. Anyone had a similar experience? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Oct 8, 8:29 pm, Rob Sargent <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> I haven''t seen anyone mention this yet. > > The tail end of the migration process is a call to schema.dump. Our > primary keys are uuids and these choke schema.dump on both oracle and > postgres. The latter fails silently (skips three tables) while the > former complains about the RAW(16) in each of the three tables. > > Anyone had a similar experience?If you are using stuff the ruby schema dumper does not understand you may just have to switch the schema dumper format to :sql (in environment.rb), although this does tend to kill cross database compatibility. Fred> -- > Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Frederick Cheung wrote:> On Oct 8, 8:29�pm, Rob Sargent <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> > wrote: > > If you are using stuff the ruby schema dumper does not understand you > may just have to switch the schema dumper format to :sql (in > environment.rb), although this does tend to kill cross database > compatibility. > > FredOK, I''ll look into that. Thank -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Rob Sargent wrote:> > > Frederick Cheung wrote: >> On Oct 8, 8:29�pm, Rob Sargent <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> >> wrote: >> >> If you are using stuff the ruby schema dumper does not understand you >> may just have to switch the schema dumper format to :sql (in >> environment.rb), although this does tend to kill cross database >> compatibility. >> >> Fred > > OK, I''ll look into that. ThankSetting ''config.active_record.schema_format = :sql'' in environment.rb appears to have turned dump off altogether. Was that the expected result? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 8 Oct 2008, at 21:41, Rob Sargent wrote:> > Rob Sargent wrote: >> >> >> Frederick Cheung wrote: >>> On Oct 8, 8:29�pm, Rob Sargent <rails-mailing-l...-ARtvInVfO7m5VldFQK4jKA@public.gmane.orgt> >>> wrote: >>> >>> If you are using stuff the ruby schema dumper does not understand >>> you >>> may just have to switch the schema dumper format to :sql (in >>> environment.rb), although this does tend to kill cross database >>> compatibility. >>> >>> Fred >> >> OK, I''ll look into that. Thank > > Setting ''config.active_record.schema_format = :sql'' in environment.rb > appears to have turned dump off altogether. Was that the expected > result?Yes. Instead db/development.sql (if you are doing this in the development environment) is populated. IIRC it''s not automatically updated after migrations have run. Fred --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Frederick Cheung wrote:> On 8 Oct 2008, at 21:41, Rob Sargent wrote: > >>>> may just have to switch the schema dumper format to :sql (in >>>> environment.rb), although this does tend to kill cross database >>>> compatibility. >>>> >>>> Fred >>> >>> OK, I''ll look into that. Thank >> >> Setting ''config.active_record.schema_format = :sql'' in environment.rb >> appears to have turned dump off altogether. Was that the expected >> result? > > Yes. Instead db/development.sql (if you are doing this in the > development environment) is populated. IIRC it''s not automatically > updated after migrations have run. > > FredFred, Thanks, I''m not seeing anything but the same dud schema.rb being generated so I''m still doing something wrong (using rake db:schema:dump) -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---