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.
Can someone please enlighten me as to what is going on?
Thanks,
Chris