Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Tom Lane
Bernd Helmle maili...@oopsware.de writes: --On 18. Mai 2010 23:20:26 +0200 Jesper Krogh jes...@krogh.cc wrote: May I ask whats the reason is for breaking the compatibillity? Efficency, if i am allowed to call it this way. The new hex representation should be more efficient to retrieve and to

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Stefan Kaltenbrunner
On 05/19/2010 08:13 AM, Tom Lane wrote: Bernd Helmle maili...@oopsware.de writes: --On 18. Mai 2010 23:20:26 +0200 Jesper Krogh jes...@krogh.cc wrote: May I ask whats the reason is for breaking the compatibillity? Efficency, if i am allowed to call it this way. The new hex representation

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Robert Haas
On Wed, May 19, 2010 at 10:17 AM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: On 05/19/2010 08:13 AM, Tom Lane wrote: Bernd Helmle maili...@oopsware.de writes: --On 18. Mai 2010 23:20:26 +0200 Jesper Krogh jes...@krogh.cc wrote: May I ask whats the reason is for breaking the

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Kenneth Marshall
On Wed, May 19, 2010 at 10:54:01AM -0400, Robert Haas wrote: On Wed, May 19, 2010 at 10:17 AM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: On 05/19/2010 08:13 AM, Tom Lane wrote: Bernd Helmle maili...@oopsware.de writes: --On 18. Mai 2010 23:20:26 +0200 Jesper Krogh jes...@krogh.cc

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Robert Haas
On Wed, May 19, 2010 at 11:00 AM, Kenneth Marshall k...@rice.edu wrote: On Wed, May 19, 2010 at 10:54:01AM -0400, Robert Haas wrote: On Wed, May 19, 2010 at 10:17 AM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: On 05/19/2010 08:13 AM, Tom Lane wrote: Bernd Helmle

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 given how much faster the new format is (or rather how slow the old one was) and the number of people I have seen complaining why is bytea so slow) I would like to see it staying turned on by default. However this also depends on how

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Magnus Hagander
On Wed, May 19, 2010 at 11:06 AM, Greg Sabino Mullane g...@turnstep.com wrote: given how much faster the new format is (or rather how slow the old one was) and the number of people I have seen complaining why is bytea so slow) I would like to see it staying turned on by default. However this

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Robert Haas
On Wed, May 19, 2010 at 11:07 AM, Magnus Hagander mag...@hagander.net wrote: On Wed, May 19, 2010 at 11:06 AM, Greg Sabino Mullane g...@turnstep.com wrote: given how much faster the new format is (or rather how slow the old one was) and the number of people I have seen complaining why is

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Aidan Van Dyk
* Magnus Hagander mag...@hagander.net [100519 11:08]: How do the distros generaly deal with that? E.g. do we have to wait for RHEL7 for it to actually show up in redhat? Don't worry, 9.0 won't show up in redhat for a while yet either... ;-) -- Aidan Van Dyk

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Magnus Hagander
On Wed, May 19, 2010 at 11:11 AM, Robert Haas robertmh...@gmail.com wrote: On Wed, May 19, 2010 at 11:07 AM, Magnus Hagander mag...@hagander.net wrote: On Wed, May 19, 2010 at 11:06 AM, Greg Sabino Mullane g...@turnstep.com wrote: given how much faster the new format is (or rather how slow

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Alex Hunsaker
On Wed, May 19, 2010 at 09:05, Robert Haas robertmh...@gmail.com wrote: On Wed, May 19, 2010 at 11:00 AM, Kenneth Marshall k...@rice.edu wrote: Changing something like that within the minor release arc is not a good idea. It would be better to have it on by default and if the driver developers

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Robert Haas
On Wed, May 19, 2010 at 11:31 AM, Alex Hunsaker bada...@gmail.com wrote: On Wed, May 19, 2010 at 09:05, Robert Haas robertmh...@gmail.com wrote: On Wed, May 19, 2010 at 11:00 AM, Kenneth Marshall k...@rice.edu wrote: Changing something like that within the minor release arc is not a good idea.

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Stefan Kaltenbrunner
On 05/19/2010 11:45 AM, Robert Haas wrote: On Wed, May 19, 2010 at 11:31 AM, Alex Hunsaker bada...@gmail.com wrote: On Wed, May 19, 2010 at 09:05, Robert Haas robertmh...@gmail.com wrote: On Wed, May 19, 2010 at 11:00 AM, Kenneth Marshall k...@rice.edu wrote: Changing something like that

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Stefan Kaltenbrunner
On 05/19/2010 11:19 AM, Magnus Hagander wrote: On Wed, May 19, 2010 at 11:11 AM, Robert Haas robertmh...@gmail.com wrote: On Wed, May 19, 2010 at 11:07 AM, Magnus Hagander mag...@hagander.net wrote: On Wed, May 19, 2010 at 11:06 AM, Greg Sabino Mullane g...@turnstep.com wrote: given how

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Robert Haas
On Wed, May 19, 2010 at 12:16 PM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: I think it just depends on whether we're likely to get releases from Linux vendors that include PG 9.0 but not the updated drivers.  I'm not sure their schedule will be affected by whether we call it 8.5 or

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Stefan Kaltenbrunner
On 05/19/2010 12:32 PM, Robert Haas wrote: On Wed, May 19, 2010 at 12:16 PM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: I think it just depends on whether we're likely to get releases from Linux vendors that include PG 9.0 but not the updated drivers. I'm not sure their schedule

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Florian Pflug
On May 19, 2010, at 18:32 , Robert Haas wrote: On Wed, May 19, 2010 at 12:16 PM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: I think it just depends on whether we're likely to get releases from Linux vendors that include PG 9.0 but not the updated drivers. I'm not sure their schedule

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: On Wed, May 19, 2010 at 11:11 AM, Robert Haas robertmh...@gmail.com wrote: Yeah, that's what I'm worried about.  I remember going through this with E'' quoting.  It wasn't fun. Right. So do we know what the policy is? As long as DBD::Pg is released

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Andrew Dunstan
On Wed, May 19, 2010 1:31 pm, Tom Lane wrote: BTW, standard_conforming_strings is really a different case because of the SQL-injection security hazards with non-scs-aware client code. I don't see any comparable risk for bytea format. Yeah, and the impact of this will be much more limited.

[HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-18 Thread Jesper Krogh
Hi. I'm trying to do a test move of one of our applications onto 9.0beta1. We use storable and serializes data into a bytea column in the database. This script uses that: #!/usr/bin/perl use strict; use warnings; use Storable; use DBI; use DBD::Pg; use Data::Dumper; my $dbh =

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-18 Thread Alex Hunsaker
On Tue, May 18, 2010 at 14:54, Jesper Krogh jes...@krogh.cc wrote: Hi. I'm trying to do a test move of one of our applications onto 9.0beta1. We use storable and serializes data into a bytea column in the database. [ snip insert/select using bytea ] 8.4  id |                                

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-18 Thread Jesper Krogh
On 2010-05-18 23:12, Alex Hunsaker wrote: set bytea_output 'escape'; That was it. Knowing what the problem was I had no problem finding it in the release notes. May I ask whats the reason is for breaking the compatibillity? -- Jesper -- Sent via pgsql-hackers mailing list

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-18 Thread Alex Hunsaker
On Tue, May 18, 2010 at 15:20, Jesper Krogh jes...@krogh.cc wrote: On 2010-05-18 23:12, Alex Hunsaker wrote: set bytea_output 'escape'; That was it. Knowing what the problem was I had no problem finding it in the release notes. May I ask whats the reason is for breaking the compatibillity?

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-18 Thread Bernd Helmle
--On 18. Mai 2010 23:20:26 +0200 Jesper Krogh jes...@krogh.cc wrote: That was it. Knowing what the problem was I had no problem finding it in the release notes. May I ask whats the reason is for breaking the compatibillity? Efficency, if i am allowed to call it this way. The new hex

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-18 Thread Kenneth Marshall
On Tue, May 18, 2010 at 03:26:17PM -0600, Alex Hunsaker wrote: On Tue, May 18, 2010 at 15:20, Jesper Krogh jes...@krogh.cc wrote: On 2010-05-18 23:12, Alex Hunsaker wrote: set bytea_output 'escape'; That was it. Knowing what the problem was I had no problem finding it in the release