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.