Re: Changed Hosts, Lots of Errors in PostgreSQL - Help Please! - Mailing list pgsql-general

From Kevin Hunter
Subject Re: Changed Hosts, Lots of Errors in PostgreSQL - Help Please!
Date
Msg-id 480BF656.3090100@earlham.edu
Whole thread Raw
In response to Changed Hosts, Lots of Errors in PostgreSQL - Help Please!  (BLazeD <gibbasanti@hotmail.com>)
List pgsql-general
At 11:27p -0400 on Fri, 18 Apr 2008, BLazeD wrote:
> [quote]PHP Warning:  pg_query(): Query failed: ERROR:  operator does not
> exist: timestamp without time zone > time without time zone at character
> 14\nHINT:  No operator matches the given name and argument type(s). You
> might need to add explicit type casts.\nQUERY:  SELECT   $1  >  $2
                 ^^^^^^^^^^^^^^^^^^^^^^^
It's been awhile since I've messed with timestamps et al, but I don't
recall direct operators between timestamp and time.  In the host change,
did you also get a Postgres upgrade?  To 8.3 perhaps, that removed a lot
of explicit type casts?

> [other errors]

If that's it, I'll bet fixing the first error will fix the rest, or at
least point you in the right direction.

Kevin

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Changed Hosts, Lots of Errors in PostgreSQL - Help Please!
Next
From: Craig Ringer
Date:
Subject: Re: Changed Hosts, Lots of Errors in PostgreSQL - Help Please!