Reload TYPE ENUM (Postgre) before migration

[esdrasedu]

When you create migration with TYPE ENUM and try use ( in next migration), error is is triggered, because Postgres not find new TYPE ENUM.

If you call migration task again, error is NOT triggered, because Postgres load ENUM new .

Versions:
OS: Darwin 15.0.0
Postgre: 9.4.5
Elixir: 1.1.1
Erlang/OTP: 18
Ecto: 1.0.6
Postgrex 0.9.1

Sample

First

defmodule MyRepo.Migrations.CreateUserType do
  use Ecto.Migration

  def up do
    execute "CREATE TYPE user_status AS ENUM ('customer','admin')"

    alter table(:users) do
      add :status,    :user_status
    end
  end

  def down do
    execute "DROP TYPE user_status"
    alter table(:users) do
      remove :status
    end
  end
end

Second

defmodule MyRepo.Migrations.SeedUserType do
  use Ecto.Migration

  alias MyRepo.Repo
  alias MyRepo.User

  def up do
    Repo.update_all (from(u in User, where: u.parents < 0)), set: [status: "admin"]
  end

  def down do
    Repo.update_all User, set: [status: nil]
  end
end

Error

** (ArgumentError) no extension found for oid `29304`
    (postgrex) lib/postgrex/types.ex:280: Postgrex.Types.fetch!/2
    (postgrex) lib/postgrex/types.ex:213: Postgrex.Types.format/2
      (elixir) lib/enum.ex:1043: anonymous fn/3 in Enum.map/2
      (elixir) lib/enum.ex:1387: Enum."-reduce/3-lists^foldl/2-0-"/3
      (elixir) lib/enum.ex:1043: Enum.map/2
    (postgrex) lib/postgrex/protocol.ex:134: Postgrex.Protocol.message/3
    (postgrex) lib/postgrex/connection.ex:417: Postgrex.Connection.new_data/2
    (postgrex) lib/postgrex/connection.ex:292: Postgrex.Connection.handle_info/2

I think can having help for create type, or method for reload types enum, or after execute migrate reload types enum

[josevalim]

Thank you for the report. We need to reload the types information correctly. :)

[josevalim]

This is a postgres specific error due to the types cache. It also requires changes to the adapter API. At least the adapter API changes need to happen on 2.0.