Re: Avoid lost result of recursion (src/backend/optimizer/util/inherit.c)

David Rowley <dgrowleyml@gmail.com>

From: David Rowley <dgrowleyml@gmail.com>
To: Amit Langote <amitlangote09@gmail.com>
Cc: Richard Guo <guofenglinux@gmail.com>, Ranier Vilela <ranier.vf@gmail.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2022-12-23T03:36:14Z
Lists: pgsql-hackers
On Fri, 23 Dec 2022 at 16:22, Amit Langote <amitlangote09@gmail.com> wrote:
> Attached shows a test case I was able to come up with that I can see
> is broken by a61b1f74 though passes after applying Richard's patch.

Thanks for the test case.  I'll look at this now.

+UPDATE rootp SET b = b || 'd' RETURNING a, b, c, d;
+ a |  b   |  c  | d
+---+------+-----+---
+ 1 | food | 1.1 |

Coding on an empty stomach I see! :)

David



Commits

  1. Fix bug in translate_col_privs_multilevel

  2. Rework query relation permission checking