nted feature.
I rather fancy an extra column query_qn with the query text where all
the object names are substituted to the qualified names.
Remember that this problem isn't about only table names. The query may
have views, functions, operands etc. from the 'wrong' schema.
Sergei A
I like it. I don't want to break backward compatibility.
The new column could be named like query_qn, and will have here the
unambitious text of the query
where all the objects names are extended to the qualified names.
Sergei Agalakov
On 11/27/2018 2:17 PM, Alvaro Herrera wrote:
On 201
select count(*) from s2.t1
with an immediate understanding of what's going on.
Obviously it would be even bigger help in the situations with the more
complex queries where it will be mush more difficult to find
that the query was executed with the incorrect search_path settings.
Thank you,
Sergei Agalakov
