[postgis-devel] [PostGIS] #532: Temporary table geography columns appear in other's sessions
PostGIS
trac at osgeo.org
Fri Sep 10 08:09:15 PDT 2010
#532: Temporary table geography columns appear in other's sessions
---------------------+------------------------------------------------------
Reporter: mwtoews | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 1.5.2
Component: postgis | Version: 1.5.X
Keywords: |
---------------------+------------------------------------------------------
Comment(by pramsey):
OK, got it:
{{{
CREATE OR REPLACE VIEW geography_columns AS
SELECT
current_database() AS f_table_catalog,
n.nspname AS f_table_schema,
c.relname AS f_table_name,
a.attname AS f_geography_column,
geography_typmod_dims(a.atttypmod) AS coord_dimension,
geography_typmod_srid(a.atttypmod) AS srid,
geography_typmod_type(a.atttypmod) AS type
FROM
pg_class c,
pg_attribute a,
pg_type t,
pg_namespace n
WHERE t.typname = 'geography'
AND a.attisdropped = false
AND a.atttypid = t.oid
AND a.attrelid = c.oid
AND c.relnamespace = n.oid
AND NOT pg_is_other_temp_schema(c.relnamespace);
}}}
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/532#comment:8>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-devel
mailing list