pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedQuery failed: ERROR: Unable to identify an operator '=' for types 'character varying' and 'character'
2+ messages / 1 participants
[nested] [flat]
* Query failed: ERROR: Unable to identify an operator '=' for types 'character varying' and 'character'
@ 2004-11-12 14:14 Francisco Jose Bernabe Pellicer <fbernabe@cesga.es>
0 siblings, 0 replies; 2+ messages in thread
From: Francisco Jose Bernabe Pellicer @ 2004-11-12 14:14 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Query failed: ERROR: Unable to identify an operator '=' for types 'character varying' and 'character'
@ 2004-11-16 12:28 Francisco Jose Bernabe Pellicer <fbernabe@cesga.es>
0 siblings, 0 replies; 2+ messages in thread
From: Francisco Jose Bernabe Pellicer @ 2004-11-16 12:28 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-11-16 12:28 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-12 14:14 Query failed: ERROR: Unable to identify an operator '=' for types 'character varying' and 'character' Francisco Jose Bernabe Pellicer <fbernabe@cesga.es>
2004-11-16 12:28 Query failed: ERROR: Unable to identify an operator '=' for types 'character varying' and 'character' Francisco Jose Bernabe Pellicer <fbernabe@cesga.es>
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