Re: exception handling in plperlu - Mailing list pgsql-general

From Adam Rich
Subject Re: exception handling in plperlu
Date
Msg-id 03d101c767dc$ac9c9f00$6400a8c0@dualcore
Whole thread Raw
In response to Re: exception handling in plperlu  ("Jasbinder Singh Bali" <jsbali@gmail.com>)
List pgsql-general
You'll want something like this:
 
my $dbh = eval { DBI->connect(....);};
 
 
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Jasbinder Singh Bali
Sent: Friday, March 16, 2007 9:55 AM
To: Martijn van Oosterhout; Tom Lane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] exception handling in plperlu

just wondeng why doesn't it let me put
my $dbh=DBI->connect("dbi:Pg:dbname=dbunmask; host=192.168.0.120; port=5432;", "", "");
in eval

says
Global symbol "$dbh" requires explicit package name at line <where ever dbh is used>

Jas

On 3/16/07, Martijn van Oosterhout < kleptog@svana.org> wrote:
On Thu, Mar 15, 2007 at 10:06:06PM -0400, Jasbinder Singh Bali wrote:
> How about using a try catch block?
> isn't that more efficient that eval?

Umm, eval is perl's equivalent of try/catch. There is no other way.

Have a nice day,
--
Martijn van Oosterhout   < kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFF+oqkIB7bNG8LQkwRApyEAJ413cmp0bIuasEceWhXgTgSE6NOFACeNijH
ZHknBQrtHqg30xL8Wh219Ik=
=Xhhm
-----END PGP SIGNATURE-----


pgsql-general by date:

Previous
From: "A.M."
Date:
Subject: Re: exception handling in plperlu
Next
From: Martijn van Oosterhout
Date:
Subject: Re: exception handling in plperlu