ne 19. 12. 2021 v 8:13 odesÃlatel Pavel Stehule <pavel.steh...@gmail.com> napsal:
> > > ne 19. 12. 2021 v 8:09 odesÃlatel Erik Rijkers <e...@xs4all.nl> napsal: > >> Op 19-12-2021 om 07:23 schreef Pavel Stehule: >> >> > >> > I am sending new versions of patches. >> > >> > I hope I solved all Tomas's objections. >> > >> > 1. The schema variables were renamed to session variables >> > 2. I fixed issues related to creating, dropping variables under >> > subtransactions + regress tests >> > 3. I fixed issues in pg_dump + regress tests >> > >> >> > [0001-schema-variables-20211219.patch] >> > [0002-schema-variables-20211219.patch] >> >> Hi Pavel, >> >> I get an error during test 'session_variables'. >> >> (on the upside, my own little testsuite runs without error) >> >> thanks, >> > > please, can you send me regress diff? > I see the problem now, the test contains username, and that is wrong. Schema | Name | Type | Is nullable | Is mutable | Default | Owner | Transactional end action | Access privileges | Description -----------+------+---------+-------------+------------+---------+-------+--------------------------+------------------------+------------- - svartest | var1 | numeric | t | t | | pavel | | pavel=SW/pavel +| - | | | | | | | | var_test_role=SW/pavel | +----------+------+---------+-------------+------------+---------+----------+--------------------------+---------------------------+------------- + svartest | var1 | numeric | t | t | | appveyor | | appveyor=SW/appveyor +| + | | | | | | | | var_test_role=SW/appveyor | (1 row) REVOKE ALL ON VARIABLE var1 FROM var_test_role; I have to remove this test Pavel Regards > > Pavel > > > >> Erik Rijkers >> >> >> >> >> >> >> >> >> >>