In my schema.rb I have
  create_table "attachments", :force => true do |t|
    t.string  "original_filename"
    t.string  "content_type"
    t.binary  "content",           :limit => 16777215
    t.string  "description"
    t.integer "client_id"
  end

When I do heroku rake db:schema:load

I get:
PGError: ERROR:  type modifier is not allowed for type "bytea"
LINE 1: ... "content_type" character varying(255), "content"
bytea(1677...
                                                             ^
: CREATE TABLE "attachments" ("id" serial primary key,
"original_filename" character varying(255), "content_type" character
varying(255), "content" bytea(16777215), "description" character
varying(255), "client_id" integer)

It appears from searching this forum that Postgres does not like the
"limit" with "binary".

Does this mean that I have to edit my schema.rb or is there some other
way?

Cheers
George

-- 
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Reply via email to