Status Checking - Mailing list pgsql-interfaces

From George P. Esperanza
Subject Status Checking
Date
Msg-id Pine.LNX.4.05.9907120823360.20680-100000@calamba.laguna.net
Whole thread Raw
In response to pgAdmin 6.5.0 Released  (Dave Page <dpage@vale-housing.co.uk>)
List pgsql-interfaces

Hi!

Sorry for posting this simple question....

I'm just new to postgres and i'm using PERL interface to access my
databases.  I just want to know how can i check or get the status if my
query command has no errors.

     $dbh = Pg::connectdb("dbname=MMS");

How do i check if there's no error connecting to my database MMS?

     $sth = $dbh->exec("select syskey from syskey where syskey =                          '$syskey'");     $sth =
$dbh->exec("insertinto syskey values('$syskey', '$value',                     '$desc')");     $sth = $dbh->exec("delete
fromsyskey where val='test'");
 

How to i check if my select, insert and delete statement has no error?

Thanks...

George 

---------------------------------------------------------------------
|   George P. Esperanza                    e-mail : george@laguna.net |
|   Laguna Internet                        phone  : (049) 545-2358    |
|   6 East Arcade Calamba Trade Center                                |
|   Calamba, Laguna                                                   |
---------------------------------------------------------------------



pgsql-interfaces by date:

Previous
From: Constantin Teodorescu
Date:
Subject: Re: [INTERFACES] crypt error
Next
From: James Olin Oden
Date:
Subject: Re: [INTERFACES] Status Checking