Re: [DOCS] Doc BUG and/or Change Request: Include Postgres's systemcolumns in reserved words in docs, Chnage to previx sytem colums with 2 underscores? - Mailing list pgsql-docs
From
David G. Johnston
Subject
Re: [DOCS] Doc BUG and/or Change Request: Include Postgres's systemcolumns in reserved words in docs, Chnage to previx sytem colums with 2 underscores?
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.
From:
dan d Date: Subject:
Re: [DOCS] Doc BUG and/or Change Request: Include Postgres's systemcolumns in reserved words in docs, Chnage to previx sytem colums with 2underscores?