[postgis-devel] Issue 74 in postgis: AddGeometryColumn does not detect search_path properly
codesite-noreply at google.com
codesite-noreply at google.com
Mon Nov 24 11:29:25 PST 2008
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
More information about the postgis-devel
mailing list