Re: Proper way to clean-up connection for reuse (`DISCARD ALL` and default role)

2 (Red Hat 7.3.1-6), 64-bit ``` Le lun. 20 janv. 2025 à 18:06, Tom Lane a écrit : > Logan MAUZAIZE writes: > > 1. clarify if `DISCARD ALL` behavior is the expected one or is it a bug? > > DISCARD ALL is documented to do SET SESSION AUTHORIZATION DEFAULT, > and

Proper way to clean-up connection for reuse (`DISCARD ALL` and default role)

Hello! We encountered an issue with connection pooling from .Net driver ( https://github.com/npgsql/npgsql). A few weeks ago, in order to give same access privileges for multi-service access (service/API, https://sqitch.org/, satellite services, ...), we enabled default role (`ALTER ROLE SET ROL