Re: [PATCH] Proposal for HIDDEN/INVISIBLE column

From: Dave Cramer <davecramer(at)postgres(dot)rocks>
To: Gilles Darold <gilles(at)migops(dot)com>
Cc: Aleksander Alekseev <aleksander(at)timescale(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] Proposal for HIDDEN/INVISIBLE column
Date: 2021-10-15 13:39:36
Message-ID: CADK3HHKKQ4H06yj86iPq_S8uEqk8MbW15m7OYusnr-CO7tyzig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 15 Oct 2021 at 09:29, Gilles Darold <gilles(at)migops(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2021-10-15 13:46:18 Re: installcheck fails when compute_query_id=on or pg_stat_statsement is loaded
Previous Message Gilles Darold 2021-10-15 13:29:13 Re: [PATCH] Proposal for HIDDEN/INVISIBLE column