[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:  reopened     
  Priority:  blocker  |   Milestone:  PostGIS 1.5.2
 Component:  postgis  |     Version:  1.5.X        
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------

Comment(by robe):

 Yah that is wrong.  How about replacing pg_table_is_visible(c.oid)  with

 has_table_privilege(c.oid, 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE,
 REFERENCES, TRIGGER'::text)

 I checked information_schema.tables and that is what it uses and I
 verified it can see temp tables I created.  Its also listed in 8.3 docs so
 I think safe to use
 http://www.postgresql.org/docs/8.3/static/functions-info.html

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