Re: [GENERAL] Gripe: bytea_output default => data corruption

2010-10-22 Thread ljb
vi...@khera.org wrote: >... > I had some hoops thru which I had to jump to make our app compatible with > both 8.x and 9.x so we could safely migrate our servers without having to > coordinate a code push. It wasn't that bad, but part of the problem is that > the DBD::Pg driver does not understand

Re: [GENERAL] Gripe: bytea_output default => data corruption

2010-10-22 Thread Vick Khera
On Thu, Oct 21, 2010 at 7:12 PM, ljb wrote: > Again: My complaint is that pre-9.0 libpq-based clients mis-decode the new > default hex format bytea data without reporting an error, and this danger > is > insufficiently documented in the release notes. > I had some hoops thru which I had to jump

Re: [GENERAL] Gripe: bytea_output default => data corruption

2010-10-21 Thread ljb
br...@momjian.us wrote: >... > Yes, we mentioned that setting in the release notes too: >... > While the "Incompatibilities" section mentions only the first paragraph, > this remention lower down has even more details. Not sure what else you > wanted us to do. Here's how I would have written that

Re: [GENERAL] Gripe: bytea_output default => data corruption

2010-10-21 Thread Bruce Momjian
Rajesh Kumar Mallah wrote: > Dear Griper!, > > fortunately someone showed a easy 'fix' > > ALTER DATABASE foo SET bytea_output='escape' ; Yes, we mentioned that setting in the release notes too: E.2.3.5. Data Types * Allow bytea values to be w

Re: [GENERAL] Gripe: bytea_output default => data corruption

2010-10-14 Thread Rajesh Kumar Mallah
Dear Griper!, fortunately someone showed a easy 'fix' ALTER DATABASE foo SET bytea_output='escape' ; Regds Rajesh Kumar Mallah. On Wed, Oct 13, 2010 at 5:03 PM, ljb wrote: > r...@iol.ie wrote: >>... >> In fairness, it *is* flagged in the release note - it's the first item >> under "data type

Re: [GENERAL] Gripe: bytea_output default => data corruption

2010-10-14 Thread Raymond O'Donnell
On 13/10/2010 22:03, ljb wrote: r...@iol.ie wrote: ... In fairness, it *is* flagged in the release note - it's the first item under "data types" in the list of incompatibilities. Quote: "bytea output now appears in hex format by default (Peter Eisentraut) The server parameter bytea_

Re: [GENERAL] Gripe: bytea_output default => data corruption

2010-10-14 Thread ljb
r...@iol.ie wrote: >... > In fairness, it *is* flagged in the release note - it's the first item > under "data types" in the list of incompatibilities. Quote: "bytea output now appears in hex format by default (Peter Eisentraut) The server parameter bytea_output can be used to select the

Re: [GENERAL] Gripe: bytea_output default => data corruption

2010-10-13 Thread Dmitriy Igrishin
Hey all, And it is 9.0, i.e another major version. IMO the higher major versions not necessarily must be 100% backward compatible. So, think twice next time you update the major version. 2010/10/13 Raymond O'Donnell > On 13/10/2010 01:37, ljb wrote: > >> Defaulting bytea output from the backend

Re: [GENERAL] Gripe: bytea_output default => data corruption

2010-10-13 Thread Raymond O'Donnell
On 13/10/2010 01:37, ljb wrote: Defaulting bytea output from the backend to use hex mode encoding, which is incompatible with pre-9.0 interfaces, wasn't a friendly thing to do. The default should have been escape mode. Or else you needed a big warning in HISTORY that we must either change bytea_o

[GENERAL] Gripe: bytea_output default => data corruption

2010-10-12 Thread ljb
Defaulting bytea output from the backend to use hex mode encoding, which is incompatible with pre-9.0 interfaces, wasn't a friendly thing to do. The default should have been escape mode. Or else you needed a big warning in HISTORY that we must either change bytea_output, or upgrade all clients befo