Does Drizzle autogenerate prepared statements under the hood?
Supabase is telling me that PGBouncer and their own Supavisor both don't support prepared statements. We don't use prepared statement but I see queries that look like autogenerated prepared statement ids
If so, can we disable it?
7 Replies
Seeing messages like
prepared statement "l1wmyog929416" does not exist
prepared statement"ye655i5hxc396" does not exist
PostgresJS does autogenerate, if you're using that
https://github.com/porsager/postgres#prepared-statements
GitHub
GitHub - porsager/postgres: Postgres.js - The Fastest full featured...
Postgres.js - The Fastest full featured PostgreSQL client for Node.js and Deno - GitHub - porsager/postgres: Postgres.js - The Fastest full featured PostgreSQL client for Node.js and Deno
@kratious do you know if pg does as well? We're on postgres.js but can swap over to prevent the named statements
are you using transactions ?
pg doesn't. You can turn off the autogenerating with
prepare: false
for postgres.js toonot much. maybe one or two
got it -- thanks
i had to stop using transactions and i stopped getting that issue