Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 91DBD64FD49 for ; Sun, 28 Dec 2008 23:30:15 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 45291-09 for ; Sun, 28 Dec 2008 23:30:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.kulmacet.com (static-71-244-46-202.dllstx.fios.verizon.net [71.244.46.202]) by mail.postgresql.org (Postfix) with ESMTP id 8362764FD46 for ; Sun, 28 Dec 2008 23:30:11 -0400 (AST) Received: (qmail 13857 invoked by uid 509); 28 Dec 2008 21:30:09 -0600 Received: from 172.16.1.96 by mail.kulmacet.com (envelope-from , uid 507) with qmail-scanner-1.25-st-qms (clamdscan: 0.87/3517. spamassassin: 3.0.2. perlscan: 1.25-st-qms. Clear:RC:0(172.16.1.96):SA:0(-5.7/5.0):. Processed in 0.778324 secs); 29 Dec 2008 03:30:09 -0000 X-Antivirus-MYDOMAIN-Mail-From: kulmacet101@kulmacet.com via mail.kulmacet.com X-Antivirus-MYDOMAIN: 1.25-st-qms (Clear:RC:0(172.16.1.96):SA:0(-5.7/5.0):. Processed in 0.778324 secs Process 13847) Received: from unknown (HELO webmail.kulmacet.com) (kulmacet101@kulmacet.com@172.16.1.96) by mail.kulmacet.com with SMTP; 28 Dec 2008 21:30:08 -0600 Received: from 172.16.1.188 (SquirrelMail authenticated user kulmacet101@kulmacet.com) by webmail.kulmacet.com with HTTP; Sun, 28 Dec 2008 21:30:05 -0600 (CST) Message-ID: <9357e6cdeccf06da015ea1534503b877.squirrel@webmail.kulmacet.com> In-Reply-To: <493fbfece44a60104d80bcafedc91780.squirrel@webmail.kulmacet.com> References: <493fbfece44a60104d80bcafedc91780.squirrel@webmail.kulmacet.com> Date: Sun, 28 Dec 2008 21:30:05 -0600 (CST) Subject: You might need to add explicit type casts. From: kulmacet101@kulmacet.com To: pgsql-php@postgresql.org. User-Agent: SquirrelMail/1.4.17 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/7 X-Sequence-Number: 3941 I have a table running on Linux\Postgresql 8.3.4: CREATE TABLE "public"."active_sessions" ( "id" VARCHAR(11) DEFAULT nextval('id_seq'::regclass) NOT NULL, "browser_type" VARCHAR(100), "session_id" VARCHAR(50), "ip_address" INET, "username" VARCHAR(50), "access_time" TIMESTAMP WITHOUT TIME ZONE, "user_rand" VARCHAR(15), "user_activity" TIMESTAMP WITHOUT TIME ZONE, CONSTRAINT "active_sessions_pkey" PRIMARY KEY("id") ) WITHOUT OIDS; I can insert the TIMESTAMP('s) into this table without issue but when I update the new entry the following error is received: ERROR: operator does not exist: character varying = integer at character 75 HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. STATEMENT: UPDATE active_sessions SET access_time = '12/28/2008 8:51:33 PM' WHERE id = 469 I have read several archives describing the 8.3 release notes and CASTing but I do not understand how to apply this information, this issue makes no sense. Insert = ok, Update = "BOOM!". I have tried this statement with CURRENT_TIMESTAMP, now() but neither works. This statement is created using PHP 5.2.6 on a Linux server using PDO and prepared statements Any help with this issue is appreciated. Thanks in advance, Kulmacet