Skip site navigation (1) Skip section navigation (2)

Re: Changed Hosts, Lots of Errors in PostgreSQL - Help Please!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: BLazeD <gibbasanti(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Changed Hosts, Lots of Errors in PostgreSQL - Help Please!
Date: 2008-04-21 01:25:38
Message-ID: 16072.1208741138@sss.pgh.pa.us (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-general
BLazeD <gibbasanti(at)hotmail(dot)com> writes:
> [quote]PHP Warning:  pg_query(): Query failed: ERROR:  operator does not
> exist: timestamp without time zone > time without time zone at character
> 14

Well, it's quite right, there is no such operator.

PG 8.3 complains about this, whereas previous versions would have
silently converted both operands to text and done a textual comparison
... leading to results that are highly unlikely to be sane at all,
for this combination of datatypes.  I'd say 8.3 just found a bug in
your app for you.

> [quote]PHP Warning:  pg_query(): Query failed: ERROR:  function
> pg_catalog.btrim(bigint) does not exist at character 62

Again, this is 8.3 being more picky about implicit casts than prior
versions.  Why would you think btrim on an integer value would be
useful, anyway?  If you really want it, insert an explicit cast
to text.

			regards, tom lane

In response to

pgsql-general by date

Next:From: Kevin HunterDate: 2008-04-21 02:05:10
Subject: Re: Changed Hosts, Lots of Errors in PostgreSQL - Help Please!
Previous:From: christian_behrensDate: 2008-04-20 22:19:34
Subject: Need to update all my 60 million rows at once without transactional integrity

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group