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

change of tenant for multi tenancy using pgxpool #2053

Open
yakkalabhargav235 opened this issue Jun 21, 2024 · 0 comments
Open

change of tenant for multi tenancy using pgxpool #2053

yakkalabhargav235 opened this issue Jun 21, 2024 · 0 comments

Comments

@yakkalabhargav235
Copy link

Hi @jackc , previous discussions had conveyed in wrong way in the issue https://github.com/jackc/pgx/issues/2007.
As per the suggestions given in previous chat. I had tried by setting up DefaultQueryExecMode to QueryExecModeSimpleProtocol. which results in creating a new connection every time and does not releases the connections after executing query.
I had removed the immutable from procedures. Everything is working as expected.
But only query is when procedures are immutable, the results of pgx are not matched with results using jdbc. May I know the reason?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant