I''m using Postgresql as my database backend, and whenver I run "rake db:schema:dump", the following line appears in db/schema.rb: # Could not dump table "comments" because of following StandardError # Unknown type ''inet'' for column ''ip'' Anyone encountered this problem before and found a way around it? -- 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 -~----------~----~----~----~------~----~------~--~---
you have a postgresql INET column type in your table. INET is not a ''standard'' SQL column type and rails is telling you it doesn''t understand the type. On 3/16/07, David Edwards <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > I''m using Postgresql as my database backend, and whenver I run "rake > db:schema:dump", the following line appears in db/schema.rb: > > # Could not dump table "comments" because of following StandardError > # Unknown type ''inet'' for column ''ip'' > > Anyone encountered this problem before and found a way around it? > > -- > 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 -~----------~----~----~----~------~----~------~--~---
as far as a way around it goes, i don''t think there is much of anything you can do other than changing the column type or not using rake db:schema:dump. On 3/16/07, Chris Hall <christopher.k.hall-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> you have a postgresql INET column type in your table. INET is not a > ''standard'' SQL column type and rails is telling you it doesn''t > understand the type. > > > > On 3/16/07, David Edwards <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote: > > > > I''m using Postgresql as my database backend, and whenver I run "rake > > db:schema:dump", the following line appears in db/schema.rb: > > > > # Could not dump table "comments" because of following StandardError > > # Unknown type ''inet'' for column ''ip'' > > > > Anyone encountered this problem before and found a way around it? > > > > -- > > 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 -~----------~----~----~----~------~----~------~--~---
set config.active_record.schema_format = :sql in config/environment.rb ? 2007/3/16, David Edwards <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>:> > I''m using Postgresql as my database backend, and whenver I run "rake > db:schema:dump", the following line appears in db/schema.rb: > > # Could not dump table "comments" because of following StandardError > # Unknown type ''inet'' for column ''ip'' > > Anyone encountered this problem before and found a way around it? > > -- > 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 -~----------~----~----~----~------~----~------~--~---
I added support for the inet and cidr datatypes to the PostgreSQL adapter and that support currently lives in Edge Rails. Try it out! -- Roderick van Domburg http://www.nedforce.com -- 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 -~----------~----~----~----~------~----~------~--~---