pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Francisco Jose Bernabe Pellicer <fbernabe@cesga.es>
To: pgsql-admin@postgresql.org
Subject: Query failed: ERROR: Unable to identify an operator '=' for types 'character varying' and 'character'
Date: Tue, 16 Nov 2004 13:28:52 +0100
Message-ID: <4199F284.3020706@cesga.es> (raw)

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






view thread (2+ messages)

Message-ID: <4199F284.3020706@cesga.es>
Permalink:  ../4199F284.3020706@cesga.es/
Also on:    postgresql.org/message-id/4199F284.3020706@cesga.es

 · 

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-admin@postgresql.org
  Cc: fbernabe@cesga.es
  Subject: Re: Query failed: ERROR: Unable to identify an operator '=' for types 'character varying' and 'character'
  In-Reply-To: <4199F284.3020706@cesga.es>
  References: <4199F284.3020706@cesga.es>

* 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