> On 30 Mar 2023, at 22:29, Tom Lane <[email protected]> wrote: > Daniel Gustafsson <[email protected]> writes: >>> On 30 Mar 2023, at 20:44, Tom Lane <[email protected]> wrote:
>>> Another idea could be for pg_regress to enforce that "select count(*) >>> from pg_roles" gives the same answer before and after the test run. > >> That wouldn't prevent the contents of pg_roles to have changed though, so >> there >> is a (slim) false positive risk with that no? > > Well, we could do "select rolname from pg_roles order by 1" and > actually compare the results of the two selects. That might be > advisable anyway, in order to produce a complaint with useful > detail when there is something wrong. I can see the value in doing something like this to keep us honest. -- Daniel Gustafsson
