Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 19B0B6335C2 for ; Fri, 19 Mar 2010 04:24:45 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 08251-03-6 for ; Fri, 19 Mar 2010 07:24:29 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.csc.lt (mail.csc.lt [193.138.191.5]) by mail.postgresql.org (Postfix) with ESMTP id 86281634C66 for ; Fri, 19 Mar 2010 04:24:09 -0300 (ADT) Received: (qmail 12188 invoked by uid 210); 19 Mar 2010 07:24:07 -0000 Received: from mail.nsoft.lt by mail.csc.lt (envelope-from , uid 201) with qmail-scanner-2.05st (clamdscan: 0.95.3/10595. spamassassin: 3.2.1. perlscan: 2.05st. Clear:RC:1(77.240.249.53):. Processed in 0.011532 secs); 19 Mar 2010 07:24:07 -0000 Received: from mail.nsoft.lt (77.240.249.53) by mail.csc.lt with SMTP; 19 Mar 2010 07:24:07 -0000 Received: from [192.168.16.103] (unknown [77.240.249.53]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) by mail.nsoft.lt (Postfix) with ESMTPS id 108D68E045 for ; Fri, 19 Mar 2010 08:38:16 +0200 (EET) Message-ID: <4BA32695.1090402@nsoft.lt> Date: Fri, 19 Mar 2010 09:24:05 +0200 From: Julius Tuskenis Organization: UAB nSoft User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; lt; rv:1.9.1.8) Gecko/20100227 Lightning/1.0b1 Thunderbird/3.0.3 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: operator does not exist Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.708 tagged_above=-10 required=5 tests=AWL=0.892, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/134 X-Sequence-Number: 33933 Hello, we updated one of our systems from postgresql 8.2 to 8.3 and now some queries are generating errors that no operator matches the given name and argument type. That is not surprising as in v8.3 the automatic casting was removed what troubles me is that sometimes it still casts select '1' = 1 results in true while select sum(msg_price) from messages where msg_itemid = 0 results in error: ERROR: operator does not exist: character varying = integer LINE 1: select sum(msg_price) from messages where msg_itemid = 0 I will add the operator ant then we'll fix the queries, but is the first example ok? Should it not raise error ? -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050