Transactions, PgBouncer/Supavisor, prepared statements
okay... i have spent way to long trying to figure out why when using transactions and a pooler on transaction mode it causes the connection to reset mid transaction statement causing a
prepared statement 'name' does not exist which was very hard to debug.
still don't fully understand why transaction won't work i've tried everything i could find setting params binary_parameters=yes (not even sure what this does, resetting database server (supabase). using a direct connection worked but wasn't something i could do forever.
so my fix was.... just remove transactions from my endpoints (which sucks but it is what it is)
if anyone else has this issue would love some help on how you worked around this or fixed???1 Reply
Bump, having this error now myself