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 3F80D529F3 for ; Tue, 9 Aug 2005 14:28:05 -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 87218-02 for ; Tue, 9 Aug 2005 17:27:56 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.195]) by svr1.postgresql.org (Postfix) with ESMTP id 35C8E529C0 for ; Tue, 9 Aug 2005 14:27:55 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 8so187769nzo for ; Tue, 09 Aug 2005 10:27:55 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=KSGzvpWDXjO+YfrtfzHG8p6vGTZwbqZ54DoXPQQ3MXuUNZCcKBGj1RPXbTogqTurhBXVzpkYNTYb6PvcyJtPwoORwT3ywQWKJ3/YY5MrlcHjXAr7fERxWU7vd3v3wqz24AEN3ZK6Frf6NWt6gLiZWVH0q2W1dvw1vprnJCJviVY= Received: by 10.36.148.15 with SMTP id v15mr268450nzd; Tue, 09 Aug 2005 10:27:55 -0700 (PDT) Received: by 10.36.24.2 with HTTP; Tue, 9 Aug 2005 10:27:55 -0700 (PDT) Message-ID: <1d219a6f05080910277cbf10b2@mail.gmail.com> Date: Tue, 9 Aug 2005 13:27:55 -0400 From: Chris Hoover To: pgsql-admin@postgresql.org Subject: PG 7.3.4 VS PG 8.0.3 Problem Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200508/112 X-Sequence-Number: 18431 I am having an issue with 7.3.4 vs 8.0.3. I have done a simple conversion of one of my databases from 7.3.4 to 8.0.3. I used the 8.0.3 pg_dump to dump the database and load via psql 8.0.3. However, I am having a problem. I have a query that our application generates that is returning different results back to our application. When I connect to a 7.3.4 database, the query returns 0 rows and a sqlca.sqlcode of 0 However, when I connect to an 8.0.3 database, the query returns 0 rows and a sqlca.sqlcode of 100. Why is the 8.0.3 database returning a different code? Our application is checking the code returned, and since it is getting a 100, it is not performing as expected (as compared to our 7.3.4 production system). Anyway, the only thing that has changed in the environment is the PostgreSQL db. The Application and odbc drivers are all the same.=20 Can someone please enlighten me as to what is going on? Thanks, Chris