On Fri, Dec 8, 2017 at 8:12 AM, David G. Johnston <david.g.johns...@gmail.com> wrote: > Probably -bugs (or -general if you are unsure about the buggy-ness) would > have been a more appropriate list since this is all direct SQL that looks to > be broken. No use moving it now, though.
On HEAD, REL_10_STABLE or REL9_6_STABLE, say with two users: =# create role popo1 superuser login; CREATE ROLE Time: 9.400 ms =# create role popo2 login; CREATE ROLE And then by creating objects: =# select current_role; current_user -------------- popo1 (1 row) =# set role popo2; SET => select current_role; current_user -------------- popo2 (1 row) => create table aa (a int); CREATE TABLE => select current_role; current_user -------------- popo2 (1 row) => reset role; RESET =# select current_role; current_user -------------- popo1 (1 row) Per the information you are giving, I would have seen "popo2" as user for the last query even after issuing a RESET ROLE. However I do not see any problems. > Reporting the version(s) you are running would be helpful. Indeed. -- Michael
