X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6CE483A230E for ; Tue, 16 Nov 2004 12:29:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99405-04 for ; Tue, 16 Nov 2004 12:28:54 +0000 (GMT) Received: from ns1.cesga.es (ns1.cesga.es [193.144.33.38]) by svr1.postgresql.org (Postfix) with ESMTP id 49FC53A1D8F for ; Tue, 16 Nov 2004 12:28:55 +0000 (GMT) Received: from cesga.es (bream.cesga.es [193.144.44.37]) by ns1.cesga.es (8.12.9/8.12.9) with ESMTP id iAGCSq3X003762 for ; Tue, 16 Nov 2004 13:28:53 +0100 (CET) Message-ID: <4199F284.3020706@cesga.es> Date: Tue, 16 Nov 2004 13:28:52 +0100 From: Francisco Jose Bernabe Pellicer Reply-To: fbernabe@cesga.es User-Agent: Mozilla/5.0 (X11; U; Linux i686; es-ES; rv:1.4.3) Gecko/20040930 X-Accept-Language: es-es, es MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Query failed: ERROR: Unable to identify an operator '=' for types 'character varying' and 'character' Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/132 X-Sequence-Number: 15516 Hello everybody, I'm working with a monitoring tool for Grid enviroments. The thing is that, this tool (GridICE) works uses a PosgreSQL Database. I get an error at this part of the code: -------------------------------------------------------------------- $siteName = $_GET["siteName"]; $VOName = $_GET["VOName"]; $status = $_GET["status"]; $d_start = $_GET["d_start"]; $d_start_cb = $_GET["d_start_cb"]; $d_stop = $_GET["d_stop"]; $d_stop_cb = $_GET["d_stop_cb"]; $offset = $_GET["offset"]; $cr = $_GET["cr"]; $fixedJobsOpt = $_GET["fixed"]; $offset_next = $offset+$NUM_JOBS_PER_PAGE; $offset_prev = $offset-$NUM_JOBS_PER_PAGE; if($d_start_cb!='true')$d_start=0; if($d_stop_cb!='true')$d_stop=0; $fixedJobs = 'false'; if ($fixedJobsOpt == 'on') {$fixedJobs = 'true';} //***************** start table center ****************** $sql="select \"LocalID\",\"Name\",\"GlobalID\",\"JobStatus\",\"LocalOwner\",\"ExecutionTarget\",\"CPUTime\",\"WallTime\",\"ExitStatus\",\"CreationTime\",\"StartTime\",\"EndTime\",\"RAMUsed\",\"VirtualUsed\",\"Group\",\"VOName\",\"GlobalOwner\" from \"getJobDetail\"('$siteName','$VOName','$status', $fixedJobs, ".convert_date_str_dateSec($d_start).",".convert_date_str_dateSec($d_stop).",$NUM_JOBS_PER_PAGE+1,$offset)"; echo $sql; if($d_start=='')$d_start=(date("d")-1).date("/m/Y-H:i"); if($d_stop=='')$d_stop=date("d/m/Y-H:i"); //echo $sql; $rs = pg_query ($conn, $sql); -----> line 76 $getSiteVoJob=array(); $i=0; while ($row = pg_fetch_row($rs)) { ---------> line 71 $getSiteVoJob[$i]=$row; $i++; } $getSiteVoJobSize=sizeof($getSiteVoJob); ----------------------------------------------------------------------------------------------------------------- The error that I get is the following one: *Warning*: pg_query(): Query failed: ERROR: Unable to identify an operator '=' for types 'character varying' and 'character' You will have to retype this query using an explicit cast . in */var/www/html/gridice/site/jd.php* on line *67* *Warning*: pg_fetch_row(): supplied argument is not a valid PostgreSQL result resource in */var/www/html/gridice/site/jd.php* on line *71 D*oes anyone how to solve it? Cheers, _______________________________________________________ Francisco José Bernabé Pellicer Grid System Technician Técnicos del C.E.S.G.A Centro de Supercomputación de Galicia www.cesga.es Avda. deVigo s/n (Campus Sur) 15706 Santiago de Compostela (La Coruña) Spain ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org