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
still don't fully understand why transaction won't work i've tried everything i could find setting params
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???
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???
