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)
I resolved this with: