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

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