Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 865032E2DE1 for ; Sat, 17 Nov 2007 16:16:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 58239-09 for ; Sat, 17 Nov 2007 16:16:49 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 9E52C2E2D41 for ; Sat, 17 Nov 2007 16:16:51 -0400 (AST) Received: from [192.168.1.4] (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id lAHKWlGq008656 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sat, 17 Nov 2007 12:32:51 -0800 Message-ID: <473F4C26.3090907@commandprompt.com> Date: Sat, 17 Nov 2007 12:16:38 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 1.5.0.13 (Windows/20070809) MIME-Version: 1.0 To: Bruce Momjian CC: Tom Lane , josh@agliodbs.com, pgsql-docs@postgresql.org Subject: Re: [pgsql-advocacy] Avoiding upgrade backlash References: <200711171134.lAHBYnt11239@momjian.us> In-Reply-To: <200711171134.lAHBYnt11239@momjian.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Sat, 17 Nov 2007 12:32:52 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/63 X-Sequence-Number: 4596 Bruce Momjian wrote: > Tom Lane wrote: >> Josh Berkus writes: >>> Hmmm. I don't feel like it contains a clear warning, though. We need a >>> statement like: >>> Some users may encounter issues upgrading due to the changes in handling >>> data type casts. If you suspect that your schema or application may not >>> be handling data type comparisons cleanly, you are strongly urged to test >>> for casting error messages before upgrading your production server. >> When have we ever suggested that people *shouldn't* test their apps >> before committing to a major version update? >> >> I think the whole thing has been significantly overblown. We have made >> incompatible changes bigger than this one --- and, often, harder to find >> let alone fix --- in almost every major release. This one you can at >> least be pretty sure that you will get an error, and not a silent change >> in behavior, if you fall foul of it. > > Agreed. Honestly, I think you are underestimating this problem. I know that every single one of our customers is going to run into this and as much as I would like to say otherwise, the world has many more postgresql users than I have customers. This needs to be a dominant statement not only in the release notes but in the FAQ and frankly we should be running some up to the release announcements on -general and possibly the website about this change, how it manifests itself and explicit examples on how to resolve it. Joshua D. Drake