On 2020-05-27 15:59, Stephen Frost wrote:
Agreed- let's remove the legacy options. As I've mentioned elsewhere, distros may manage the issue for us, and if we want to get into it, we could consider adding support to pg_upgrade to complain if it comes across a legacy setting that isn't valid. I'm not sure that's worthwhile though.
More along these lines: We could also remove the ENCRYPTED and UNENCRYPTED keywords from CREATE and ALTER ROLE. AFAICT, these have never been emitted by pg_dump or psql, so there are no concerns from that end. Thoughts?
-- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services