[postgis-devel] Typmod Goodness

[Paragon Corporation]

Paul and Kevin,
I disagree with the pg_table_is_visible = true addition (if it ensures only
tables in your search path).

The reason being -- isn't this supposed to be like a geometry_columns

Lets say you logically divide your database by departmental schemas (or us
states or function (e.g hydrology, assessing etc.) -- normally you just
query a certain one, but I would often
want to query other departmental/state tables even if they aren't in my
search path and I would fully qualify those.  Shouldn't I be able to see the
geometry/geography meta data of these without switching my search_path?

Thanks,
Regina 

-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Friday, August 07, 2009 2:20 PM
To: PostGIS Development Discussion
Subject: Re: [postgis-devel] Typmod Goodness

On Fri, Aug 7, 2009 at 11:13 AM, Kevin Neufeld<kneufeld at refractions.net>
wrote:
> Paul Ramsey wrote:
>>>
>>> And, may I ask why you filtered out pg_temp tables?  Why would you 
>>> not what to list geography columns on any temporary tables you may 
>>> have made?
>>
>> I'll turn the question back to you, since I created the view by 
>> copying populate_geometry_columns :)
>
> :) Ah.  populate_geometry_columns repopulates geometry_columns from 
> all geometry columns detected in the database.  The pg_temp filter is 
> used here for the main reason that without it, temporary tables from 
> *all* users would be retrieved. It's not appropriate (or permissible) 
> to access a temp table in another users' session ... so why even list 
> them in the first place, right?  Also, another albeit weak answer is 
> that since it's a static table (not a view) listing a geometry column 
> that will disappear in the very near future may not seem like a good thing
to do.
>
>
> With the geography_columns view, you would need the pg_temp filter IF 
> you don't have the additional filter of pg_table_is_visible().  But if 
> you're only looking at tables in your search_path (which can't 
> possible include temp tables of other users), then you would have the 
> option to list temp tables that are, in fact, available to you.
>
>
> Anywho, it's just a thought for discussion.  I don't know what the 
> specs say about it.

The specs are silent. I've incorporated both your suggestions.

P
_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel