Re: Proposal to suppress errors thrown by to_reg*()

From: Takuma Hoshiai <hoshiai(at)sraoss(dot)co(dot)jp>
To: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposal to suppress errors thrown by to_reg*()
Date: 2019-08-01 08:42:09
Message-ID: 20190801174209.3eecce2a666fce3a1f01257e@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 1 Aug 2019 20:21:57 +1200
Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:

> On Wed, Jul 31, 2019 at 4:24 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Takuma Hoshiai <hoshiai(at)sraoss(dot)co(dot)jp> writes:
> > > [ fix_to_reg_v2.patch ]
> >
> > I took a quick look through this patch. I'm on board with the goal
> > of not having schema-access violations throw an error in these
> > functions, but the implementation feels pretty ugly and bolted-on.
> > Nobody who had designed the code to do this from the beginning
> > would have chosen to parse the names twice, much less check the
> > ACLs twice which is what's going to happen in the success path.
> >
> > But a worse problem is that this only fixes the issue for the
> > object name proper. to_regprocedure and to_regoperator also
> > have type name(s) to think about, and this doesn't fix the
> > problem for those:
>
> ...
>
> > So I think you ought to drop this implementation and fix it properly
> > by adjusting the behaviors of the functions cited above.
>
> Hello Hoshiai-san,
>
> Based on the above review, I have set this to 'Returned with
> feedback'. If you plan to produce a new patch in time for the next
> Commitfest in September, please let me know very soon and I'll change
> it to 'Moved to next CF', but otherwise please feel free to create a
> new entry when you are ready.

Yes, I plan to create next patch, Would you change it to 'Moved to next CF'?

Best Regards,

--
Takuma Hoshiai <hoshiai(at)sraoss(dot)co(dot)jp>

> Thanks!
>
> --
> Thomas Munro
> https://enterprisedb.com
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2019-08-01 08:44:42 Re: progress report for ANALYZE
Previous Message Jeevan Ladhe 2019-08-01 08:40:08 Re: concerns around pg_lsn