For the above PostgreSQL, PostGIS comes bundled with some 1050 functions. It seems these functions can only be loaded into ONE schema per database.
We have 3 three schemas (Production, Temporary, Public) in our database. We loaded those postgis functions to public.
We have set our search_path to (production, temporary, public).
Still it seems we when run out of, say, temporary we must dot the postgis function with "
We were thinking that if our search path was set as above we would not have to "dot" the function. We interface with postgis via DevArt libraries from a vb .net application.
I'm pretty new to postgis and from my reading you can only have these functions in ONE schema; however, this seems a bit restrictive.
Also in pgAdmin when I open the tree view under our database there is an Extensions folder with two items. Opening the Extensions folder exposes a postgis and a plpgsql folder. If I select properties for the postgis folder and navigate to the Definition tab here is where the postgis functions are set to install. In our case public is set and here it seems only one schema can be set.
So is this a limitation one must live with, is this the best configuration, or is there some other configuration or setting which must be made to make the PostGIS functions global?