X-Original-To: pgsql-odbc-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 38DEDD1ED6C for ; Sun, 4 Apr 2004 21:50:44 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 87545-07 for ; Sun, 4 Apr 2004 18:51:06 -0300 (ADT) Received: from FE-mail04.sfg.albacom.net (FE-mail04.albacom.net [213.217.149.84]) by svr1.postgresql.org (Postfix) with ESMTP id 8428FD1ED1A for ; Sun, 4 Apr 2004 18:50:41 -0300 (ADT) Received: from [10.0.0.10] (213.255.89.24) by FE-mail04.sfg.albacom.net (7.0.009) (authenticated as ALS04419@Albaclick.com) id 406E6A1900007B92 for pgsql-odbc@postgresql.org; Sun, 4 Apr 2004 23:51:09 +0200 Mime-Version: 1.0 (Apple Message framework v613) In-Reply-To: <20827.1081055086@sss.pgh.pa.us> References: <16E80DD4-85B9-11D8-A231-0003935B359C@cegroup.it> <20827.1081055086@sss.pgh.pa.us> Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <33898D66-8682-11D8-A231-0003935B359C@cegroup.it> Content-Transfer-Encoding: 7bit From: Jose' Cruanyes Subject: Re: invalid input syntax for type tid: "(,)" Date: Sun, 4 Apr 2004 23:51:17 +0200 To: pgsql-odbc@postgresql.org X-Mailer: Apple Mail (2.613) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/17 X-Sequence-Number: 3912 On Apr 4, 2004, at 7:04 AM, Tom Lane wrote: > "Jose' Cruanyes" writes: >> select * from table1 where ctid = '(,)'; >> [ works on some machines and not others ] > > I would argue that the ODBC driver is broken and needs to be fixed, > as does the TID input parser which should never allow this ... > > However, the reason for the platform dependency is probably that > strtoul() is setting errno on some machines and not othe since strtoul() should return 0 on an empty string, I think it will be safe to change the instances of '(,)' to '(0,0)' in the driver source code, even if it's not too clear to me what it does... I've found three, two on "convert.c" and one on "results.c" now if some one can put the changes upstream... thanks. Pax et Bonum # dott. Jose' Cruanyes Aguilar - C.E. Soft srl # Pzza. Firenze,4 MILANO - XX Settembre 10, CREMONA # 02,33603122 0372,460602