Dave Cramer <davecramer@gmail.com> writes: > Well I was presuming that they would just pass the parameter on. If they > didn't then binary_format won't work with them. In the case that they do > pass it on, then DISCARD_ALL will reset it and future borrows of the > connection will have no way to set it again; effectively making this a one > time setting.
I would not expect DISCARD ALL to reset a session-level property.
Well if we can't reset it with DISCARD ALL how would that work with pgbouncer, or any pool for that matter since it doesn't know which client asked for which (if any) OID's to be binary.