implicit type conversions - Mailing list pgsql-general

From Coby Beck
Subject implicit type conversions
Date
Msg-id 009e01c32b24$3dc40760$2401a8c0@Glenn
Whole thread Raw
Responses Re: implicit type conversions
List 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



pgsql-general by date:

Previous
From: "Coby Beck"
Date:
Subject: create or replace for aggregate function
Next
From: Alvaro Herrera
Date:
Subject: Re: Nulls get converted to 0 problem