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

2008-04-23 Thread BLazeD
Hey there Yup it went from 8.1.9 to 8.3 Adrian Klaver wrote: > > On Friday 18 April 2008 8:27 pm, BLazeD wrote: >> Hi All >> >> I recently changed hosts for my PHP/PostgreSQL site and have been seeing >> alot of errors in the errors logs and also some on the site. >> >> [quote]PHP Warning: p

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

2008-04-20 Thread Craig Ringer
Craig Ringer wrote: BLazeD wrote: [quote]PHP Warning: pg_query(): Query failed: ERROR: operator does not exist: timestamp without time zone > time without time zone That's really odd. I can't imagine why the timestamp > timestamp operator might be absent. Hmm I managed to read that erro

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

2008-04-20 Thread Kevin Hunter
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 t

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

2008-04-20 Thread Tom Lane
BLazeD <[EMAIL PROTECTED]> 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 w

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

2008-04-20 Thread Adrian Klaver
On Friday 18 April 2008 8:27 pm, BLazeD wrote: > Hi All > > I recently changed hosts for my PHP/PostgreSQL site and have been seeing > alot of errors in the errors logs and also some on the site. > > [quote]PHP Warning: pg_query(): Query failed: ERROR: operator does not > exist: timestamp without

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

2008-04-20 Thread Craig Ringer
BLazeD wrote: [quote]PHP Warning: pg_query(): Query failed: ERROR: operator does not exist: timestamp without time zone > time without time zone That's really odd. I can't imagine why the timestamp > timestamp operator might be absent. What's the output of the command "select version()" on y

[GENERAL] Changed Hosts, Lots of Errors in PostgreSQL - Help Please!

2008-04-20 Thread BLazeD
Hi All I recently changed hosts for my PHP/PostgreSQL site and have been seeing alot of errors in the errors logs and also some on the site. [quote]PHP Warning: pg_query(): Query failed: ERROR: operator does not exist: timestamp without time zone > time without time zone at character 14\nHINT: