[postgis-devel] Issue 74 in postgis: AddGeometryColumn does not detect search_path properly

[codesite-noreply at google.com]

Status: New
Owner: ke... at refractions.net

New issue 74 by ke... at refractions.net: AddGeometryColumn does not detect  
search_path properly
http://code.google.com/p/postgis/issues/detail?id=74

What steps will reproduce the problem?
1. CREATE SCHEMA tmp;
2. CREATE SCHMEA tmp2;
3. CREATE TABLE tmp2.foo2();
4. SET search_path to tmp, tmp2, public;
5. SELECT addgeometrycolumn('foo2','the_geom',3005,'POINT',2);

What is the expected output?
               addgeometrycolumn
----------------------------------------------
  tmp2.foo2.the_geom SRID:3005 TYPE:POINT DIMS:2


What do you see instead?
ERROR:  relation "tmp.foo2" does not exist



We should be using pg_catalog.pg_table_is_visible(oid) instead of
current_schema to look for the schema name of the table.

-- 
You received this message because you are listed in the owner
or CC fields of this issue, or because you starred this issue.
You may adjust your issue notification preferences at:
http://code.google.com/hosting/settings