Re: Doc BUG and/or Change Request: Include Postgres's system columns in reserved words in docs, Chnage to previx sytem colums with 2 underscores?

On Tue, Oct 3, 2017 at 10:34 AM, dan d <dano2k3(at)hotmail(dot)com> wrote:

> The fix is really simply prefix system reserved column names with one or
> two underscores. Simple clean prevents the issue between user code and
> database code...
>
The challenge isn't in making the fix (though it would likely be extremely
tedious). The challenge is compatibility given the the current state has
been in place for decades; system columns are user-visible.

This seems like a case where the cure is potentially worse than the
disease. It is difficult to please everyone and since this particular
problem is very end-user specific whereas a change would impact many
perfectly fine applications it seems like displeasing the unique end-user
(and thus retain the status quo) is likely to prevail even were someone to
invest the time to write a patch. Though, unless someone is seriously
offering to write such a patch wondering whether it would be accepted is
not particularly productive.

David J.