From: | philwalk <nomaps(at)frii(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | operator does not exist: timestamp w/out timezone (similar to bug 3807) |
Date: | 2008-04-12 02:53:40 |
Message-ID: | 1207968820.21252.7.camel@quadc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
-- Easy to duplicate on 3 different operating systems, by executing the
-- following script via psql -f pg83bug.sql
-- begin script pg83bug.sql
\set VERBOSITY verbose;
drop table if exists bugtab;
select version();
create table bugtab (
date timestamp without time zone not null
,pnum numeric
);
update bugtab set
pnum = -8.6
where date like '2007-01-19%';
-- end script pg83bug.sql
The error message reported on 3 different operating systems:
DROP TABLE
version
--------------------------------------------------------------------------------------------------------
PostgreSQL 8.3.0 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20070925 (Red Hat 4.1.2-33)
(1 row)
CREATE TABLE
psql:pg83bug.sql:16: ERROR: operator does not exist: timestamp without
time zone ~~ unknown
LINE 3: where date like '2007-01-19%';
^
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
DROP TABLE
version
-----------------------------------------------------------------------------------------------
PostgreSQL 8.3.1 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.2.3
(Ubuntu 4.2.3-2ubuntu4)
(1 row)
CREATE TABLE
psql:pg83bug.sql:16: ERROR: operator does not exist: timestamp without
time zone ~~ unknown
LINE 3: where date like '2007-01-19%';
^
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
DROP TABLE
version
-----------------------------------------------------
PostgreSQL 8.3.0, compiled by Visual C++ build 1400
(1 row)
CREATE TABLE
psql:pg83bug.sql:16: ERROR: operator does not exist: timestamp without
time zone ~~ unknown at character 50
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
psql:pg83bug.sql:16: LINE 3: where date like '2007-01-19%';
psql:pg83bug.sql:16:
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Smet | 2008-04-12 08:47:06 | Re: operator does not exist: timestamp w/out timezone (similar to bug 3807) |
Previous Message | John R Pierce | 2008-04-11 19:11:06 | Re: BUG #4104: Uninstall/remove not working correctly |