RE: Does DBD::Pg work w/mp2?

2003-06-22 Thread Marc M. Adkins
> Is anyone using PostgreSQL via DBD::Pg in a threaded environment?
> 
> It appears as though the DBD::Pg driver hasn't been made thread-safe yet.
> However it's possible that I'm misusing it somehow, doing something in my
> startup.pl that I shouldn't, whatever.  So I'm asking if anyone else is
> using DBD::Pg successfully w/mp2 at the current time???

>From the DBD::Pg mailing list:

-

The version in CVS should work with threading, but the version on CPAN 
does not yet. You can download a cvs copy:

http://gborg.postgresql.org/project/dbdpg/projdisplay.php

or just add these three lines to Pg.pm and recompile:

diff -c -r1.37 Pg.pm
*** Pg.pm   10 Jun 2003 19:14:53 - 
 1.37
--- Pg.pm   22 Jun 2003 21:22:31 -
***
*** 38,43 
--- 38,47 
  $errstr = ""; # holds error string for DBI::errstr
  $drh = undef; # holds driver handle once initialized
  
+   sub CLONE {
+   $drh = undef ;
+   }
+ 
  sub driver{
return $drh if $drh;
my($class, $attr) = @_;

-

I've tried it and it seems to work just fine.

mma



informational notice in Makefile.PL

2003-06-22 Thread Shannon Eric Peevey
Hi!

In an attempt to simplify the install process for dependencies with my 
modules, I have been using the ExtUtils::AutoInstall module.  (Great 
module, BTW :) )  But, with the current state of affairs with mod_perl 
and its availability from CPAN, I wanted to through an information 
notice to the effect of, "if you are planning to use mod_perl2 and 
apache2, you will have to answer no here, and manually download it from 
perl.apache.org..."  I contacted Autrijus Tang, the maintainer of 
ExtUtils::AutoInstall, and asked him if it was possible, (I didn't see 
it documented), and he answered with this:

   # notify the user about mod_perl 2
   BEGIN { print q{
    NOTICE *
   If you are planning to use mod_perl2 and Apache2, please, do not
   answer yes when prompted to install mod_perl.  You will need to
   download mod_perl2 manually from
   http://perl.apache.org/download/index.html
   *
   } }
I placed it after the first BEGIN block and voila! I am communicating :)

Hope this helps someone.

speeves
cws