Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Track parameter status changes across clients #3

Open
levkk opened this issue Jan 9, 2025 · 0 comments
Open

Track parameter status changes across clients #3

levkk opened this issue Jan 9, 2025 · 0 comments
Labels
backend Feature to manage backend connections frontend Client-facing feature

Comments

@levkk
Copy link
Owner

levkk commented Jan 9, 2025

In transaction mode, track parameter status updates, e.g. SET statement_timeout TO '30s';, and make sure they are cleaned up before a connection is placed back into the pool. This avoids backend connection contamination, especially in cases when pg_dump resets the search_path and client connections throw "table doesn't exist" errors (very scary in production).

Track which client sets which parameters and restore them before the connection is given to the client. This allows persisting session-level state across transactions in transaction pooling mode.

@levkk levkk added backend Feature to manage backend connections frontend Client-facing feature labels Jan 9, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
backend Feature to manage backend connections frontend Client-facing feature
Projects
None yet
Development

No branches or pull requests

1 participant