Error Geo.PostGIS.Types.find/2 is undefined (module Geo.PostGIS.Types is not available)

Questions / Help
1

My current relevent versions:

      {:ecto, "3.13.0"},

      {:ecto_sql, "\~> 3.10"},

      {:postgrex, ">= 0.0.0"},

      {:geo, "\~> 4.0.0"},

      {:geo_postgis, "\~>  3.7.1"},

Already defined custom types:

Postgrex.Types.define(
  MyApp.PostgresTypes,
  [Geo.PostGIS.Extension] ++ Ecto.Adapters.Postgres.extensions(),
json: Jason)

Setup on the Repo Config:

  # Configure your local dev database
config :my_app, MyApp.Repo,
  username: "postgres",
  password: "password",
  hostname: "localhost",
  database: "dev",
  stacktrace: true,
  show_sensitive_data_on_connection_error: true,
  pool_size: 10,
  adapter: Ecto.Adapters.Postgres,
  types: MyApp.PostgresTypes

I keep getting this error:


 GenServer {Postgrex.TypeManager, {Geo.PostGIS.Types, {~c"localhost", 5432, "dev"}}} terminating
** (UndefinedFunctionError) function Geo.PostGIS.Types.find/2 is undefined (module Geo.PostGIS.Types is not available)

Only workaround has been to use raw SQL.

2

Does the atom Geo.PostGIS.Types appear anywhere in your application? Looking at the source of geo-postgis doesn’t turn up any references…

1 Like
3

The issue was the setup. I was reading outdated docs it seems.

In a postgres_types.ex file I had:

Postgrex.Types.define(
  MyApp.PostgresTypes,
  [Geo.PostGIS.Extension] ++ Ecto.Adapters.Postgres.extensions(),
  json: Jason
)

and in my repo.ex file I originally had:


defmodule MyApp.Repo do
  use Ecto.Repo,
    otp_app: :my_app,
    adapter: Ecto.Adapters.Postgres,
    types: MyApp.PostgresTypes

end

But that was not registering the module correctly.
Trying a bunch of random solutions, I eventually found this to work.

SOLUTION:

defmodule MyApp.Repo do
  use Ecto.Repo,
    otp_app: :MyApp,
    adapter: Ecto.Adapters.Postgres
   # Removed the types: ..  part that was here.

  @impl true

  def init(_type, config) do
    {:ok, Keyword.put(config, :types, MyApp.PostgresTypes)}
  end
  # ^ Adding this fixed it.

end

The main issue was the docs for post_gis only describe how to setup outside of Phoenix. i.e. They don’t detail how to setup the Repo when the Repo is initialised via this method.