PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit
Indeed it is possible my extension is messing up the behavior because event triggers are firing on the CREATE events. But there is no SET ROLE happening in the event triggers.
Michael Paquier <michael.paquier@gmail.com> writes: > 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.
Yeah, I also failed to reproduce it (on yesterday's HEAD, though I'd be surprised if older versions were busted like this either). I'm wondering if Jeremy has some extension installed that is messing with the behavior.