Re: Misleading error "permission denied for table"

2024-10-21 Thread Ashutosh Bapat
On Wed, Oct 16, 2024 at 10:11 PM Tom Lane wrote: > > Nathan Bossart writes: > > On Wed, Oct 16, 2024 at 07:36:29PM +0530, Ashutosh Bapat wrote: > >> Shouldn't we report "permission defined for column atest5.three? > > > We do have "permission denied for column" messages in aclchk.c (e.g., > > acl

Re: Misleading error "permission denied for table"

2024-10-16 Thread Tom Lane
Nathan Bossart writes: > On Wed, Oct 16, 2024 at 07:36:29PM +0530, Ashutosh Bapat wrote: >> Shouldn't we report "permission defined for column atest5.three? > We do have "permission denied for column" messages in aclchk.c (e.g., > aclcheck_error_col()), but I don't see them actually used anywhere

Re: Misleading error "permission denied for table"

2024-10-16 Thread Nathan Bossart
On Wed, Oct 16, 2024 at 07:36:29PM +0530, Ashutosh Bapat wrote: > In privileges.sql there are tests for column level privileges e.g. > > INSERT INTO atest5(two) VALUES (6) ON CONFLICT (two) DO UPDATE set > three = 10 RETURNING atest5.three; > ERROR: permission denied for table atest5 > > In the