supabase: POSTGIS_TIGER_GEOCODER Extension Functions Don't Exist

I’m trying to use reverse geocodes on my project, so I run this code in the sql editor which successfully installs the extensions I need. I already have Postgis installed.

CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION postgis_tiger_geocoder;
CREATE EXTENSION address_standardizer;

Returns success.

But then whenever I try to use a simple function of the extension to verify it has been installed successfully which is like: SELECT na.address, na.streetname,na.streettypeabbrev, na.zip FROM normalize_address('1 Devonshire Place, Boston, MA 02109') AS na; Returns the error: “Failed to run sql query: function normalize_address(unknown) does not exist”

I tried installing the required extensions manually from the dashboard but that doesn’t help either I keep getting the error that the functions don’t exist. I tried running different functions, but none of them work. I would appreciate any help, thank you.

About this issue

  • Original URL
  • State: closed
  • Created 4 years ago
  • Comments: 23 (12 by maintainers)

Most upvoted comments

I resolved this with:

SET search_path TO tiger, extensions, public;

select tiger.reverse_geocode(x), * from ...;