Re: psql internals queries breaks in presence of user-defined operators - Mailing list pgsql-hackers

From Tom Lane
Subject Re: psql internals queries breaks in presence of user-defined operators
Date
Msg-id 1083856.1782398206@sss.pgh.pa.us
Whole thread
In response to psql internals queries breaks in presence of user-defined operators  (Kirill Reshke <reshkekirill@gmail.com>)
List pgsql-hackers
Kirill Reshke <reshkekirill@gmail.com> writes:
> If a user creates a malformed operator in theirs database, like:
> ...
> then psql's meta-commands queries like \du stop working.

Yup.

> I think this can be enhanced a little by schema-qualifying psql's
> internal query.

This has been discussed and rejected before.  Fully schema-qualifying
those queries would make them unreadable and close to unmaintainable.
And before you say that readability doesn't matter here: you're wrong.
Lots of people look at these queries via "psql -E" to see how to query
the catalogs.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Nisha Moond
Date:
Subject: Re: Proposal: Conflict log history table for Logical Replication
Next
From: "David E. Wheeler"
Date:
Subject: Re: glob support in extension_control_path/dynamic_library_path?