Re: [HACKERS] get rid of SQL_ASCII?

2013-09-06 Thread Craig Ringer
On 09/05/2013 08:47 PM, Peter Eisentraut wrote: Other ideas? Are there legitimate uses for SQL_ASCII? IMO people who want SQL_ASCII should actually be storing everything in `bytea`; that's a truer reflection of what they're actually storing, retrieving, and working with and how they're doing

Re: [HACKERS] get rid of SQL_ASCII?

2013-09-06 Thread Florian Weimer
On 09/06/2013 09:14 AM, Craig Ringer wrote: On 09/05/2013 08:47 PM, Peter Eisentraut wrote: Other ideas? Are there legitimate uses for SQL_ASCII? IMO people who want SQL_ASCII should actually be storing everything in `bytea`; that's a truer reflection of what they're actually storing,

Re: [HACKERS] get rid of SQL_ASCII?

2013-09-06 Thread Tom Lane
Craig Ringer cr...@2ndquadrant.com writes: What we SHOULD be doing is making it an explicit decision to use SQL_ASCII, and NEVER creating a cluster or database with that encoding by default. Ever. If we can't decide what the correct default encoding is (say, if locale is C) we should error out

Re: [HACKERS] get rid of SQL_ASCII?

2013-09-06 Thread Robert Haas
On Fri, Sep 6, 2013 at 10:19 AM, Tom Lane t...@sss.pgh.pa.us wrote: There's a large undercurrent of I say it's bad for you in this thread, with frankly nothing to back it up. If we try to be as nanny-ish as you're suggesting here, we'll just annoy users. +1. -- Robert Haas EnterpriseDB:

Re: [HACKERS] get rid of SQL_ASCII?

2013-09-06 Thread Kevin Grittner
Robert Haas robertmh...@gmail.com wrote: Tom Lane t...@sss.pgh.pa.us wrote: There's a large undercurrent of I say it's bad for you in this thread, with frankly nothing to back it up.  If we try to be as nanny-ish as you're suggesting here, we'll just annoy users. +1. +1 I can definitely

[HACKERS] get rid of SQL_ASCII?

2013-09-05 Thread Peter Eisentraut
Can we consider getting rid of the SQL_ASCII server-side encoding? I don't see any good use for it, and it's often a support annoyance, and it leaves warts all over the code. This would presumably be a multi-release effort. As a first step in accommodating users who have existing SQL_ASCII

Re: [HACKERS] get rid of SQL_ASCII?

2013-09-05 Thread Merlin Moncure
On Thu, Sep 5, 2013 at 7:47 AM, Peter Eisentraut pete...@gmx.net wrote: Can we consider getting rid of the SQL_ASCII server-side encoding? I don't see any good use for it, and it's often a support annoyance, and it leaves warts all over the code. This would presumably be a multi-release

Re: [HACKERS] get rid of SQL_ASCII?

2013-09-05 Thread Heikki Linnakangas
On 05.09.2013 15:47, Peter Eisentraut wrote: Can we consider getting rid of the SQL_ASCII server-side encoding? I don't see any good use for it, and it's often a support annoyance, and it leaves warts all over the code. This would presumably be a multi-release effort. I think warts all over

Re: [HACKERS] get rid of SQL_ASCII?

2013-09-05 Thread k...@rice.edu
On Thu, Sep 05, 2013 at 08:47:32AM -0400, Peter Eisentraut wrote: Can we consider getting rid of the SQL_ASCII server-side encoding? I don't see any good use for it, and it's often a support annoyance, and it leaves warts all over the code. This would presumably be a multi-release effort.

Re: [HACKERS] get rid of SQL_ASCII?

2013-09-05 Thread Alvaro Herrera
Joshua D. Drake wrote: On 09/05/2013 09:42 AM, Josh Berkus wrote: Other ideas? Are there legitimate uses for SQL_ASCII? Migrating from MySQL. We've had some projects where we couldn't fix MySQL's non-enforcement text garbage, and had to use SQL_ASCII on the receiving side. If it

Re: [HACKERS] get rid of SQL_ASCII?

2013-09-05 Thread Josh Berkus
Peter, Other ideas? Are there legitimate uses for SQL_ASCII? Migrating from MySQL. We've had some projects where we couldn't fix MySQL's non-enforcement text garbage, and had to use SQL_ASCII on the receiving side. If it hadn't been available, the user would have given up on Postgres. --

Re: [HACKERS] get rid of SQL_ASCII?

2013-09-05 Thread k...@rice.edu
On Thu, Sep 05, 2013 at 09:42:17AM -0700, Josh Berkus wrote: Peter, Other ideas? Are there legitimate uses for SQL_ASCII? Migrating from MySQL. We've had some projects where we couldn't fix MySQL's non-enforcement text garbage, and had to use SQL_ASCII on the receiving side. If it

Re: [HACKERS] get rid of SQL_ASCII?

2013-09-05 Thread Josh Berkus
On 09/05/2013 10:02 AM, Alvaro Herrera wrote: Joshua D. Drake wrote: iconv? Command Prompt helped a customer normalize encodings in their data, which was a mixture of Latin1 and UTF8. PGLoader was used for this, in two stages; the first run in UTF8 saved the rejected data to a file which

Re: [HACKERS] get rid of SQL_ASCII?

2013-09-05 Thread k...@rice.edu
On Thu, Sep 05, 2013 at 09:53:18AM -0700, Joshua D. Drake wrote: On 09/05/2013 09:42 AM, Josh Berkus wrote: Peter, Other ideas? Are there legitimate uses for SQL_ASCII? Migrating from MySQL. We've had some projects where we couldn't fix MySQL's non-enforcement text garbage, and had

Re: [HACKERS] get rid of SQL_ASCII?

2013-09-05 Thread Joshua D. Drake
On 09/05/2013 09:42 AM, Josh Berkus wrote: Peter, Other ideas? Are there legitimate uses for SQL_ASCII? Migrating from MySQL. We've had some projects where we couldn't fix MySQL's non-enforcement text garbage, and had to use SQL_ASCII on the receiving side. If it hadn't been available,