[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