[postgis-devel] Typmod Goodness
Paul Ramsey
pramsey at cleverelephant.ca
Fri Aug 7 10:42:15 PDT 2009
On Fri, Aug 7, 2009 at 10:40 AM, Kevin Neufeld<kneufeld at refractions.net> wrote:
> That is very kewl Paul! I can hardly wait for this to someday make it's way
> to the geometry data type.
>
> These are probably whole other discussion items, but you could even add
> "AND pg_catalog.pg_table_is_visible(c.oid)"
> to your view to filter out entries not in the user's current search_path.
Hm, I wonder if that's desired or not :/ I guess for privacy in some
database settings you'd want that, to keep restricted users in the
dark. I await the general consensus.
> 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 :)
P.
More information about the postgis-devel
mailing list