Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



BLazeD <gibbasanti@xxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux