Is a recompile necessary if upgrading from 9.2.0 to 9.2.1? This is for
ESQL/C, ABF and java apps.
We have to upgrade from 9.2.0 to 9.2.1 so we can apply a specific
patch and was wondering if we can simply upgrade the DBMS or if a
recompile is required. I was wondering if anybody else has gone down
this path..
John Howell

We use ABF applications compiled on 9.0.4 on different servers with
9.0, 9.1 and 9.2. No recompiliation is needed.

On Jul 13, 2:06*pm, Qld Ingres User Group <q... (AT) internode (DOT) on.net>
wrote:
John,

The answer is yes, in most cases both for abf and esql. The Java apps
should be OK as they don't normally use the Ingres libraries. It is
not possible to determine [without effort] what changes were made to
the libraries. In a lot of cases the apps will run without any
problems, but could coredump for unknown reasons. If that happens then
a recompile is always the first port of call. The downside for not
doing it on day 1 is that over time people tend to forget about the
upgrade and then believe the problem is not related to the upgrade but
to something else. Always a recipe for danger and in the end can cause
problems downstream.

Sidney