Here is my problem :
Actually I am using postgresql 9.4 and postGIS extension.
I am creating a database, and adding new tables with no problems... with geometry data types... until now...
Now, I don't know why, I suddently have to "choose schema" to get my data-type...
I am using pgadminIII to create my table, so I add a new table, and when I try to add a new column, I write the column name, then in data-type I try to type "geometry" and it does not work anymore... i have now to write "public.geometry" since the geometry type is registered in the public schema... I'm at the 30th table, and on the previous ones I didn't have to do that, the manager recognized directly the geometry type...
The postgis extension is effective and registered on my db (functions & extension ok),
Anybody has an idea on :
- How I got this... why is it happening now...
- How to solve that... (it's quite boring to type that, AND I'm afraid that when I will have to make queries on this table I will have troubles calling postgis functions without giving the schema name...)
Thanks for reading/help
Edit :
Here is the search path :
Here is what I mean when I say "public."dataType :