> On 30 Mar 2023, at 22:29, Tom Lane <t...@sss.pgh.pa.us> wrote: > Daniel Gustafsson <dan...@yesql.se> writes: >>> On 30 Mar 2023, at 20:44, Tom Lane <t...@sss.pgh.pa.us> 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