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

From: Kevin Hunter <hunteke(at)earlham(dot)edu>
To: BLazeD <gibbasanti(at)hotmail(dot)com>
Cc: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Changed Hosts, Lots of Errors in PostgreSQL - Help Please!
Date: 2008-04-21 02:05:10
Message-ID: 480BF656.3090100@earlham.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2008-04-21 02:51:01 Re: Changed Hosts, Lots of Errors in PostgreSQL - Help Please!
Previous Message Tom Lane 2008-04-21 01:25:38 Re: Changed Hosts, Lots of Errors in PostgreSQL - Help Please!