How to resolve the postgis "type geometry does not exist" issue on installing tiger_g
I have installed postgis extension in my db and I have few columns associated with its type in few tables and now I would like to use reverse geocode functionality in my app and hence I tried to create postgis_tiger_geocoder extension and I get the error as
type geometry does not existI tried to drop the extension and create it newly and it works. But I lose all my columns with the type
postgis.geography(Polygon,4326)postgis.geography(Point,4326)So, how can I repair or reinstall postgis extension without losing the columns and install the postgis_tiger_extension?
Thanks in Advance!
أكثر...
I have installed postgis extension in my db and I have few columns associated with its type in few tables and now I would like to use reverse geocode functionality in my app and hence I tried to create postgis_tiger_geocoder extension and I get the error as
type geometry does not existI tried to drop the extension and create it newly and it works. But I lose all my columns with the type
postgis.geography(Polygon,4326)postgis.geography(Point,4326)So, how can I repair or reinstall postgis extension without losing the columns and install the postgis_tiger_extension?
Thanks in Advance!
أكثر...