perl Pg module and result status

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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