npgsql: In 5.0 throws standard_conforming_strings must be on
In 5.0 standard_conforming_strings must be on we set this setting in database, but we use PgBouncer and it sets standard_conforming_strings = off (select from pg_settings returns source = session), i think if standard_conforming_strings must be on, need sets it in StartupMessage
About this issue
- Original URL
- State: closed
- Created 4 years ago
- Reactions: 1
- Comments: 17 (9 by maintainers)
Commits related to this issue
- Bring back non-standard string support Closes #3333 — committed to roji/Npgsql by roji 4 years ago
- Bring back non-standard string support (#3377) Closes #3333 — committed to npgsql/npgsql by roji 4 years ago
- Bring back non-standard string support (#3377) Closes #3333 (cherry picked from commit 2d6693c56cadf000bceaaee48d2e980a0c0a41d5) — committed to npgsql/npgsql by roji 4 years ago
@roji our DBAs are now research this problem, I will write about the results
Will take another look, probably there’s enough info now. Anyway, it looks like a limitation by your setup, so nothing should be done on our side, but having a description here would be good. Therefore, will close after testing with the configuration provided and posting back.