Re: BUG #18928: postgres_fdw search_path not reset causing pgbouncer pool_mode=transaction using the wrong schema
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Matheus Alcantara <matheusssilv97@gmail.com>
Cc: jackie.space@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2025-05-14T15:30:12Z
Lists: pgsql-bugs
ISTM the problem described here is a failure on PgBouncer's part: it is failing to maintain the illusion of a separate connection per user. I don't know that much about PgBouncer, but perhaps you just have it configured wrong? regards, tom lane