jeremyevans/sequel — Issue #397: set_column_type broken for PostgreSQL
Author: obfuscurity
Created: 2011-11-08 14:03:10+00:00
State: open

It seems that set_column_type() is not working with PostgreSQL. The corresponding SQL works as expected. The migration executes without errors but has no effect on the table. I'm using Sequel version 3.29.0.

```ruby
Sequel.migration do
up do
alter_table(:users) do
set_column_type(:timezone, 'varchar(32)')
end
end
down do
alter_table(:users) do
set_column_type(:timezone, 'varchar(8)')
end
end
end
```
Running it from psql works fine:

```ruby
foobar=> ALTER TABLE users ALTER COLUMN timezone TYPE varchar(32);
ALTER TABLE
foobar=>
```