[postgis-devel] [PostGIS] #532: Temporary table geography columns appear in other's sessions

[PostGIS]

#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.