pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [INTERFACES] Status Checking
2+ messages / 2 participants
[nested] [flat]
* Status Checking
@ 1999-07-12 16:34 George P. Esperanza <george@calamba.laguna.net>
1999-07-12 03:41 ` Re: [INTERFACES] Status Checking James Olin Oden <joden@lee.k12.nc.us>
0 siblings, 1 reply; 2+ messages in thread
From: George P. Esperanza @ 1999-07-12 16:34 UTC (permalink / raw)
To: 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("insert into syskey values('$syskey', '$value',
'$desc')");
$sth = $dbh->exec("delete from syskey 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 |
---------------------------------------------------------------------
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] Status Checking
1999-07-12 16:34 Status Checking George P. Esperanza <george@calamba.laguna.net>
@ 1999-07-12 03:41 ` James Olin Oden <joden@lee.k12.nc.us>
0 siblings, 0 replies; 2+ messages in thread
From: James Olin Oden @ 1999-07-12 03:41 UTC (permalink / raw)
To: George P. Esperanza <george@calamba.laguna.net>; +Cc: 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("insert into syskey values('$syskey', '$value',
> '$desc')");
> $sth = $dbh->exec("delete from syskey where val='test'");
>
> How to i check if my select, insert and delete statement has no error?
>
All of these questions can be answered by typing:
man Pg
and reading the text.
Cheers...james
>
> Thanks...
>
> George
>
> ---------------------------------------------------------------------
> | George P. Esperanza e-mail : george@laguna.net |
> | Laguna Internet phone : (049) 545-2358 |
> | 6 East Arcade Calamba Trade Center |
> | Calamba, Laguna |
> ---------------------------------------------------------------------
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-07-12 16:34 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-07-12 16:34 Status Checking George P. Esperanza <george@calamba.laguna.net>
1999-07-12 03:41 ` James Olin Oden <joden@lee.k12.nc.us>
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