X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 75538529B5; Tue, 9 Aug 2005 17:20:22 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82766-06; Tue, 9 Aug 2005 20:20:12 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 296E552B2A; Tue, 9 Aug 2005 17:20:10 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j79KK4WC018732; Tue, 9 Aug 2005 16:20:04 -0400 (EDT) To: Chris Hoover Cc: pgsql-odbc@postgresql.org, Michael Fuhr , pgsql-admin@postgresql.org Subject: Re: PG 7.3.4 VS PG 8.0.3 Problem In-reply-to: <1d219a6f05080913185bba2683@mail.gmail.com> References: <1d219a6f05080910277cbf10b2@mail.gmail.com> <20050809183443.GA25232@winnie.fuhr.org> <1d219a6f050809120320cb1acb@mail.gmail.com> <18535.1123617605@sss.pgh.pa.us> <1d219a6f05080913185bba2683@mail.gmail.com> Comments: In-reply-to Chris Hoover message dated "Tue, 09 Aug 2005 16:18:04 -0400" Date: Tue, 09 Aug 2005 16:20:04 -0400 Message-ID: <18731.1123618804@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200508/121 X-Sequence-Number: 18440 Chris Hoover writes: > This is what is pointing me to a problem with one of the db's. It > appears that the sqlca code has had to of changed between the 7.3.4 > and 8 code and is now behaving in a different (and unexpected) manner. There is no "sqlca" in the backend protocol at all, so I really dunno what is causing the change in behavior. > BTW, which version is correct? Should a no rows return query give a 0 > or a 100? I suspect 100 is correct, but you'd have to go read the ODBC spec to be sure. regards, tom lane