| From: | Fernán Agüero <fernan(at)iib(dot)unsam(dot)edu(dot)ar> | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | perl Pg module and result status | 
| Date: | 2000-09-20 23:59:41 | 
| Message-ID: | 20000920.23594100@iib005.iib.unsam.edu.ar | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Dear all: i am somewhat new to both perl and PostgreSQL. I am writing 
some perl scripts to store and retrieve information in a pgsql database, 
using the Pg perl module. However i am having trouble doing checks after 
issuing queries or commands. 
According to the module documentation:
"
$result_status = $result->resultStatus
Returns the status of the result. For comparing the status you may use 
one of the following constants depending upon the command executed:
- PGRES_EMPTY_QUERY
- PGRES_COMMAND_OK
- PGRES_TUPLES_OK
- PGRES_COPY_OUT
- PGRES_COPY_IN
- PGRES_BAD_RESPONSE
- PGRES_NONFATAL_ERROR
- PGRES_FATAL_ERROR
"
When I check the contents of $result_status it is not any of the 
mentioned constants, but a number (i am now getting 7 for a 
$result->getvalue command after a failed select statement). If i issue 
the same select statement in the pgsql terminal everything works. Thus i 
don't understand what could be happening.
However, comparisons of the kind of:
	if ($result_status != PGRES_COMMAND_OK) 
appear to work most of the times (am i comparing against a number?)
Any help is appreciated.
Thanks in advance,
Fernan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Haberlach | 2000-09-21 00:03:33 | Public Database of zip code information | 
| Previous Message | Matthew Rice | 2000-09-20 23:51:38 | Re: Public Database of zip code information |