pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Hoover <revoohc@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-odbc@postgresql.org
Cc: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: PG 7.3.4 VS PG 8.0.3 Problem
Date: Tue, 9 Aug 2005 16:18:04 -0400
Message-ID: <1d219a6f05080913185bba2683@mail.gmail.com> (raw)
In-Reply-To: <18535.1123617605@sss.pgh.pa.us>
References: <1d219a6f05080910277cbf10b2@mail.gmail.com>
	<20050809183443.GA25232@winnie.fuhr.org>
	<1d219a6f050809120320cb1acb@mail.gmail.com>
	<18535.1123617605@sss.pgh.pa.us>

Tom,

I'll send this over to the odbc list.  However, the odbc driver is
liked into our cobol environment.  I did not change the driver.  We
are running the 7.2.5 odbc driver.  This is why I am pointing to a
difference in the db responses.

The entire environment is the exactly same except for the database
versions (I am actually running the exact same code and odbc driver
against the 2 db's).  I can have the application connect via odbc to
my 7.3.4 instance and get the sqlcode of 0.  I can have the same
application with the same odbc connect via odbc to my 8.0.3 instance
and I get the sqlcode of 100.

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.

BTW, which version is correct?  Should a no rows return query give a 0 or a 100?

Chris

On 8/9/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Chris Hoover <revoohc@gmail.com> writes:
> > Anyway, I'm not sure how to give you a simple example.  We are running
> > a cobol application that is connecting to PostgreSQL via odbc.  The
> > application runs on one linux box and the database on a seperate one.
> 
> Hmm.  I seriously doubt that the server's response to the query has
> changed any.  What seems more likely is that the ODBC driver has changed
> its behavior.  Can you try linking your app with the older ODBC driver
> and running it against the newer server?
> 
> Also, pgsql-odbc is probably a better place to ask about it.
> 
>                         regards, tom lane
>



view thread (12+ messages)  latest in thread

Message-ID: <1d219a6f05080913185bba2683@mail.gmail.com>
Permalink:  ../1d219a6f05080913185bba2683@mail.gmail.com/
Also on:    postgresql.org/message-id/1d219a6f05080913185bba2683@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: revoohc@gmail.com, tgl@sss.pgh.pa.us, pgsql-odbc@postgresql.org, mike@fuhr.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>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox