Re: [perl #24463] DBI tests fail with perl 5.8.2 and -Duseithreads -Dusemultiplicity -Duse64bitint

2003-11-15 Thread Stas Bekman
Nicholas Clark wrote: On Thu, Nov 13, 2003 at 12:01:22PM -0800, Stas Bekman wrote: Well, I suggested that patch so I -Dm -Mthreads won't segfault :( Can you think of a test that would have detected a breakage? Tests for threads very welcome. I didn't ask whether tests are welcome, but what

Re: Oracle8i vs Oracle 9i and DBI/DBD issues

2003-11-15 Thread Tim Bunce
On Fri, Nov 14, 2003 at 05:16:28PM -0500, Rozengurtel, Daniel wrote: Hello All, I have rather general question. We are about to migrate to Oracle9i from 8.1.7. We are using: Perl 5.6.1 DBI 1.2 DBD::Oracle 1.12 Sun 5.8 The questions are: 1. If we do

flattening selectall_hashref results + FetchHashAsRowKey

2003-11-15 Thread Terrence Brannon
Is there anyway to flatten the results of selectall_hashref ? Here is what I had to do in my sub: sub clans { my $clan_list = $dbh-selectall_hashref($SQL, 'id'); # the flattening that I was hoping DBI could do somehow :) my @ret; for my $id (sort keys %$clan_list) { push @ret,

cost of selectall_hashref

2003-11-15 Thread tvilliers
What is the difference in cost between the fetchall_arrayref/selectall_arrayref and the fetchall_hashref/selectall_hashref methods? A slideshow presentation of Tim Bunce (April 2003: Advanced DBI) mentions the performance gains of using fetchall_arrayref when doing a single column select --

DBD-Oracle and Oracle 9

2003-11-15 Thread sam_berman
Tim, We have just moved to Oracle 9 and it appears that DBI does not support this version. The same code (which only does a connect works on other machines to which I have access that are running Oracle 8. It appears I have everything else set up correctly (ORACLE_HOME,

RE: fork and die

2003-11-15 Thread tvilliers
Thanks Jeroen, Somewhere in my quest to solve this issue, I read to first unset the child signal with $SIG{CHLD} = 'IGNORE'; ## Children die unnoticed ... and then in the child use setsid or die $!; which supposedly immediately dissociates the child from the mother, which means the mother

Re: Perl 5.8.1 and DBD::Informix compile error - SvOK_off

2003-11-15 Thread tvilliers
On Mon, 29 Sep 2003 20:54:33 -0700, Jonathan Leffler wrote: Justin Hopkins wrote: I've just installed perl 5.8.1 and while trying to reinstall DBD::Informix, I've come across this compile error on Solaris 7: ~/src/perlmod/DBD-Informix-2003.04/ make INFORMIXC=/usr/local/bin/perl esqlcc

Re: Perl 5.8.1 and DBD::Informix compile error - SvOK_off

2003-11-15 Thread tvilliers
On Mon, 29 Sep 2003 20:54:33 -0700, Jonathan Leffler wrote: Justin Hopkins wrote: I've just installed perl 5.8.1 and while trying to reinstall DBD::Informix, I've come across this compile error on Solaris 7: ~/src/perlmod/DBD-Informix-2003.04/ make INFORMIXC=/usr/local/bin/perl esqlcc

Re: DBD module

2003-11-15 Thread Scott R. Godin
Michael A Chase wrote: On Thu, 6 Nov 2003 14:07:46 -0500 [EMAIL PROTECTED] wrote: How do I determine what version of the DBD module is installed? There are several DBD::xyz modules. DBI has a method for finding them: perl -MDBI -e print join qq(\n), DBI-available_drivers You can

Re: DBD module

2003-11-15 Thread Scott R. Godin
Tim Bunce wrote: On Thu, Nov 06, 2003 at 02:07:46PM -0500, [EMAIL PROTECTED] wrote: How do I determine what version of the DBD module is installed? With DBI 1.38 you can now do perl -MDBI -e 'DBI-installed_versions' and it'll tell you. Tim. Sweet! Thanks a lot, Tim, this is nice.

Re: DBD-Oracle and Oracle 9

2003-11-15 Thread Michael A Chase
On Fri, 14 Nov 2003 11:40:53 -0500 (EST) sam_berman [EMAIL PROTECTED] wrote: We have just moved to Oracle 9 and it appears that DBI does not support this version. The same code (which only does a connect works on other machines to which I have access that are running Oracle 8. It appears I

Re: [perl #24463] DBI tests fail with perl 5.8.2 and -Duseithreads -Dusemultiplicity -Duse64bitint

2003-11-15 Thread Nicholas Clark
On Thu, Nov 13, 2003 at 12:01:22PM -0800, Stas Bekman wrote: Well, I suggested that patch so I -Dm -Mthreads won't segfault :( Can you think of a test that would have detected a breakage? Tests for threads very welcome. What I'd love to see is 5.8.3 having completely avoid calling functions

Re: [perl #24463] DBI tests fail with perl 5.8.2 and -Duseithreads -Dusemultiplicity -Duse64bitint

2003-11-15 Thread Nicholas Clark
On Fri, Nov 14, 2003 at 11:26:47PM -0800, Stas Bekman wrote: Nicholas Clark wrote: On Thu, Nov 13, 2003 at 12:01:22PM -0800, Stas Bekman wrote: Well, I suggested that patch so I -Dm -Mthreads won't segfault :( Can you think of a test that would have detected a breakage? Tests for