pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: kulmacet101@kulmacet.com
To: pgsql-php@postgresql.org.
Subject: You might need to add explicit type casts.
Date: Sun, 28 Dec 2008 21:30:05 -0600 (CST)
Message-ID: <9357e6cdeccf06da015ea1534503b877.squirrel@webmail.kulmacet.com> (raw)
In-Reply-To: <493fbfece44a60104d80bcafedc91780.squirrel@webmail.kulmacet.com>
References: <493fbfece44a60104d80bcafedc91780.squirrel@webmail.kulmacet.com>

 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





view thread (4+ messages)  latest in thread

Message-ID: <9357e6cdeccf06da015ea1534503b877.squirrel@webmail.kulmacet.com>
Permalink:  ../9357e6cdeccf06da015ea1534503b877.squirrel@webmail.kulmacet.com/
Also on:    postgresql.org/message-id/9357e6cdeccf06da015ea1534503b877.squirrel@webmail.kulmacet.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: kulmacet101@kulmacet.com, pgsql-php@postgresql.org.
  Subject: Re: You might need to add explicit type casts.
  In-Reply-To: <9357e6cdeccf06da015ea1534503b877.squirrel@webmail.kulmacet.com>
  References: <493fbfece44a60104d80bcafedc91780.squirrel@webmail.kulmacet.com> <9357e6cdeccf06da015ea1534503b877.squirrel@webmail.kulmacet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox