I have installed
postgis extension in my db. I have few columns associated with its type in few tables and now I would like to use
reverse geocode functionality in my app. Hence I tried to create
postgis_tiger_geocoder extension and I get the error as
type geometry does not exist
I tried to drop the extension and create it newly and it works. But I lose all my columns with the type
So, how can I repair or reinstall postgis extension without losing the columns and install the postgis_tiger_extension?