Re: [PATCH] Proposal for HIDDEN/INVISIBLE column - Mailing list pgsql-hackers

From Dave Cramer
Subject Re: [PATCH] Proposal for HIDDEN/INVISIBLE column
Date
Msg-id CADK3HHKKQ4H06yj86iPq_S8uEqk8MbW15m7OYusnr-CO7tyzig@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Proposal for HIDDEN/INVISIBLE column  (Gilles Darold <gilles@migops.com>)
Responses Re: [PATCH] Proposal for HIDDEN/INVISIBLE column  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-hackers


On Fri, 15 Oct 2021 at 09:29, Gilles Darold <gilles@migops.com> wrote:
Le 15/10/2021 à 14:24, Aleksander Alekseev a écrit :
> Hi Gilles,
>
>> If we really want SELECT * to be reserved to DBA then why not removing the
>> star from PG unless you have the admin privilege?
> Respectfully, I perceive this as a trolling (presumably, non-intentional one)
> and not going to answer this.


Yes, I don't wanted to offend you or to troll. This was just to point
that the position of "SELECT * is bad practice" is not a good argument
in my point of view, just because it is allowed for every one. I mean
that in an extension or a client which allow user query input we must
handle the case.


This would break an awful lot of apps.

Dave

pgsql-hackers by date:

Previous
From: Gilles Darold
Date:
Subject: Re: [PATCH] Proposal for HIDDEN/INVISIBLE column
Next
From: Tom Lane
Date:
Subject: Re: installcheck fails when compute_query_id=on or pg_stat_statsement is loaded