Ticket #72 (closed task: fixed)
ST_Estimated_Extent sometimes returns null if table exists but not in current schema
|Reported by:||robe||Owned by:||robe|
What steps will reproduce the problem? 1. Create a schema - say myschema 2. SET search_path to public,myschema; 3. SELECT ST_Estimated_Extent('somegeomtable', 'the_geom'); where the somegeomtable is in myschema schema.
What is the expected output? Either an error or the estimated extent
What do you see instead? NULL
Note: If SET search_path to myschema, public then estimated extent is correctly returned
If SET search_path to public
Then it correctly returns relation 'soemgeomtable' does not exist.
So only seems to be an issue if schema is in search path but not the first schema in search path.
Seems to happen in both 1.3.3 and 1.3.4 SVN.