[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        
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------
Comment (by mwtoews):

 This can be resolved by using the SQL statement (modified from CREATE OR
 REPLACE VIEW geography_columns):
 {{{
         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 c.relistemp OR NOT pg_is_other_temp_schema(n.oid));
 }}}
 Note: I have removed {{{c.relkind IN('r','v')}}} from the original
 definition since I'm not sure if you can have that kind mixed in with
 {{{t.typname = 'geography'}}}. Furthermore,
 {{{pg_is_other_temp_schema(oid)}}} appeared in Postgres 8.2 (judging from
 when it appeared in [[http://www.postgresql.org/docs/8.2/static/functions-
 info.html the documentation]].)

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/532#comment:1>
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.