On Monday, December 14, 2015 05:20:52 PM Adrian Klaver wrote: > > FOLLOWUP QUESTION: is there a way to ask the query planner what > > tables/fields were output in a database result? > > I am not following, that would be in the query output would it not? A > more detailed explanation of what you want to see would be helpful. The problem is that permissions were originally designed to be handled in the ORM (and they are, just fine) and read-level permissions were set up at the page level (it's a web based application) so you can either access the page or you can't. But in order to satisfy a large client, they want the guarantee of permissions at the field level. Problem is, our product has been in development for a LONG time (started when PHP3 was king of the hill) and if we did that, large, complex queries would break in many horrible ways. For example, it's typical to create a with prefix table with a 5-table query, then link to that two or three times over in order to develop a complex relationship with data, and then output the result. I may be wishing for magic, but would it be possible to be able to ask the DB server where the fields of data got their data from? (so we could squelch the output as it passes through our DB abstraction layer) EXPLAIN ANALYZE *almost* does this, thus the thought. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
