Enum in migration not working (Postgres)

[Marlysson]

Describe the bug
A migration using enum type in postgres database isn't working.

To Reproduce

1. Create a migration with table.enum('gender', ['male', 'female'])
2. Run migration

Expected behavior
Constraint check is have to create normally.

Screenshots

What database are you using?
Postgres

[josephmancuso]

Actually no. This is the proper way to create enums in Postgres we can do:

CREATE TYPE users10_genders_enum AS ENUM ('male', 'female');

create table users10(
    genders users10_genders_enum
);

[josephmancuso]

Another way all in one line and probably easier is to do this:

create table users11(
    genders VARCHAR(255) CHECK (genders = 'male' OR genders = 'female')
);

This just involves changing the male, female syntax to genders = 'male' OR genders = 'female'

[josephmancuso]

Lastly we can also do this. This requires to smallest change:

create table users12(
    genders VARCHAR(255) CHECK (genders IN ('male', 'female'))
);

This just requires adding {column} IN to the query

[josephmancuso]

postgres has so many damn ways to do this

[Marlysson]

This seems the better way:

genders VARCHAR(255) CHECK (genders IN ('male', 'female'))

I have a postgres installed, I can test against a database this behavior. Or do you think define this as a good first issue issue?

[josephmancuso]

no this needs to be fixed ASAP

[josephmancuso]

Fixed in #363