Re: exception handling in plperlu

"Adam Rich" <adam.r@xxxxxxxxxxxxx> · Fri, 16 Mar 2007 10:06:28 -0500

Title: Message

You'll 
want something like this:

my 
$dbh = eval { DBI->connect(....);};

  -----Original Message-----
From: 
  pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] 
  On Behalf Of Jasbinder Singh Bali
Sent: Friday, March 16, 
  2007 9:55 AM
To: Martijn van Oosterhout; Tom Lane; 
  pgsql-general@xxxxxxxxxxxxxx
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@xxxxxxxxx> 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@xxxxxxxxx>   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-----