Alter column length on migration for PostgreSQL db fails due to incorrect syntax

[connectedtrips]

My migration looks like:

migration 1, :modify_url_length do
up do
modify_table :hotels do
change_column :url, String, :length => 1..255
end
end

down do
modify_table :hotels do
change_column :url, String, :length => 1..255
end
end
end

However, the migration fails with the error: ERROR: syntax error at or near "VARCHAR".

Seems to me that the SQL being ran is:

ALTER TABLE "hotels" ALTER COLUMN "url" VARCHAR(1 AND 255)

when it needs to be

ALTER TABLE "hotels" ALTER COLUMN "url" TYPE VARCHAR(1 AND 255)

[vitork]

Same here... This is happening because of the PostgreSQL version.

For version 8.x, the syntax is ALTER COLUMN "column_name" VARCHAR(1 AND 255), and for version 9.x, the syntax is ALTER COLUMN "column_name" TYPE VARCHAR(1 AND 255).