[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: login errors



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 31 Jan 2008 07:22:51 -0500
john <..hidden..> wrote:

> There is another error i came across when using PG 8.3 when adding a
> vendor invoice:
> 
> ------------------------------------
> DBD::Pg::st execute failed: ERROR: operator does not exist: integer =
> text
> LINE 3: WHERE c.id = (SELECT value FROM defaults 
> ^
> HINT: No operator matches the given name and argument type(s). You
> might need to add explicit type casts.
> 


This is the one I was worried about (that and the tsearch stuff). 8.3
has removed *all* implicit casts. I am pretty sure we are going to hit
this a lot. 

Sincerely,

Joshua D. Drake


- -- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHoiuRATb/zqfZUUQRAmPNAKCuMiYw4ZA4xe3rX+QcvZuRQ8exVwCePDhB
UO4JplpzQlv9hE7fI5R7aEA=
=BCQg
-----END PGP SIGNATURE-----