implicit type conversions

From: "Coby Beck" <coby(at)vec(dot)com(dot)au>
To: <pgsql-general(at)postgresql(dot)org>
Subject: implicit type conversions
Date: 2003-06-03 02:14:46
Message-ID: 042201c32976$824ba0a0$810fddcb@Glenn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a Zope app with a postgres database. Due to boring technical
details, I am trying to port it from version 7.2.1 to 7.3.2. This is an
inherited application that is still under active development.

It seems that the older version was doing a lot of type conversions behind
the scenes because bulding the database with the new version results in a
scad of type errors. For example, many functions declared on (INTEGER) need
to be changed to (BIGINT), type (TEXT) is no longer good enough when it is
actually an integer being passed, things like this.

Is there some kind of global setting or configuration I can modify rather
than patching things all over the place? I have mixed feelings on these
kinds of behind the scenes "favours" but for now I would just like it to
work...

Thanks,

Coby Beck

Responses

Browse pgsql-general by date

  From Date Subject
Next Message nolan 2003-06-03 07:09:55 Optimizer failure on integer column?
Previous Message Bruce Momjian 2003-06-02 19:53:10 Re: [HACKERS] Are we losing momentum?