Unknown type 'inet' for column 'ip'

Rails
1

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?

2

set config.active_record.schema_format = :sql in config/environment.rb ?

2007/3/16, David E. [email protected]:

3

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.

4

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.

5

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