Re: bind_param() Doc Patch

2006-05-25 Thread David Wheeler
On May 25, 2006, at 15:26, Tim Bunce wrote: Uh, hang on, now I look at the code I see it's not checking for an undef. I guess you're getting "Can't %s->bind_col(%s, %s,...), need a reference to a scalar" Right? Yep, that's what I found. Thanks, David

bind_param() Doc Patch

2006-05-25 Thread David Wheeler
The examples under "Data Types for Column Binding" don't execute. This is because the second argument to bind_col() should be a scalar ref, and the examples just use C. Should it be C<\undef>? Best, David Index: DBI.pm === ---

Hack: Using Subclass in DBI::Shell

2006-04-18 Thread David Wheeler
Fellow DBIers, So I just had a need to use DBI::Shell with a subclass of the DBI. It doesn't support subclasses directly (it'd be nice to be able to specify one on the command-line or something), but I was able to hack it into using one anyway by doing this: BEGIN { sub DBI::Shell

installed_drivers

2006-03-02 Thread David Wheeler
Fellow DBIers, I've been having a need in my tests to be able to disconnect all current connections to a database—before I drop the database, for example. Now my code uses connect_cached(), so this used to be quite a PITA, because the DBI was keeping connections open! But then I stumbled

Re: Status of Callbacks

2005-11-03 Thread David Wheeler
On Nov 3, 2005, at 2:13 PM, Tim Bunce wrote: Because the aggregates don't persist, I need to create them for every database handle. Since I run persistent apps (with mod_perl), it's best for me to do it the first time I connect to the database. Since I use connect_cached(), It's hard to know whe

Re: Status of Callbacks

2005-11-02 Thread David Wheeler
On Nov 2, 2005, at 2:59 PM, Tim Bunce wrote: I've an assortments of changes to checkin prior to the next release, but docs for Callbacks isn't part of them. Patches most welcome. Okay. I've been rather busy for a while[1] and that won't get much better in the short term. Help would be appre

Re: Status of Callbacks

2005-11-01 Thread David Wheeler
On Nov 1, 2005, at 5:55 PM, Dean Arnold wrote: Any chance these would work in Pg's PL/perl, extproc_perl, or the (whatever MySQL does) ? No, the callbacks are just Perl code refs that get called before a method gets executed. See t/70callbacks.t in SVN. Best, David

Re: Status of Callbacks

2005-11-01 Thread David Wheeler
On Nov 1, 2005, at 12:11 PM, David Wheeler wrote: So, what's the status on Callbacks? Are they ready to go into a release? Ah, I see from this post: http://www.mail-archive.com/dbi-dev@perl.org/msg03793.html That Steven Schubiger was going to pen some docs for Callbacks. Since

Re: Status of Callbacks

2005-11-01 Thread David Wheeler
On Nov 1, 2005, at 12:19 PM, Dean Arnold wrote: Er, care to refresh our collective memories w/ the executive overview of what "callbacks" is ? My DBI inbox doesn't surface anything, and Google ain't much help either...I see a blurb in the CPAN roadmap doc, but thats it. See the thread starting

Status of Callbacks

2005-11-01 Thread David Wheeler
Hi All, I just noticed that, while the Callbacks attribute has been implemented in SVN, it still hasn't made it into a release. I could have sworn that it was a long time ago that I worked on them. And didn't I write some docs for them? So, what's the status on Callbacks? Are they ready t

Re: UTF-8 flags (again)

2005-04-22 Thread David Wheeler
On Sep 8, 2004, at 4:45 AM, Tim Bunce wrote: On Tue, Sep 07, 2004 at 04:03:21PM -0700, David Wheeler wrote: On Sun, 08 Aug 2004 12:33:22 -0700, Tim Bunce wrote: I'm thinking in terms of something like $sth->{SetUTF8}->[$index] = $mode 0: Force SvUTF8_off regardless

Re: Callback support is oin

2005-03-29 Thread David Wheeler
On Mar 29, 2005, at 12:11 PM, Tim Bunce wrote: Well, I was kinda hoping your next contribution might be an implementation of $h->{SetUTF8} :-) That would be much faster. [Look back in the archives for details.] D'oh! Anybody got any spare tuits they can give me? :-) Is there a way to set it on an e

Re: Callback support is oin

2005-03-29 Thread David Wheeler
On Mar 29, 2005, at 2:39 AM, Tim Bunce wrote: $dbh->prepare($sql, { Callbacks => { prepare => sub { ... } }); ...well, I guess it'd be pretty dumb to do that. Not if you remember that the (or at least _a_ plan) plan is to rework $dbh->prepare so it looks like this: sub prepare {

Re: Callback support is oin

2005-03-25 Thread David Wheeler
On Mar 23, 2005, at 2:01 AM, Tim Bunce wrote: I can certainly live with that. Are return values currently ignored? An exception will be thrown if anything is returned. Okay, good to note in the docs. I think I'd be inclined to have them mean nothing, and leave it up to callbacks to throw exceptions

Re: Callback support is oin

2005-03-22 Thread David Wheeler
On Mar 22, 2005, at 4:46 PM, David Wheeler wrote: Anyway, it's in now, with support for callbacks on *every* method and *every* handle. So this does what you'd expect: $dbh->{Callbacks}->{ping} => sub { print "Called ping!\n"; return; }; $d

Re: Callback support is oin

2005-03-22 Thread David Wheeler
YES! :-) On Mar 22, 2005, at 4:21 PM, Tim Bunce wrote: It ended up a little different in that I don't use an extra element in the struct but just hv_fetch "Callbacks" when needed. So it's more like the way "Profile" is handled. I should have pointed you in that direction rather than to the older Ca

Re: DBI 1.48: Warning: something's wrong at t/zvpp_11fetch.t line 3.

2005-03-16 Thread David Wheeler
On Mar 16, 2005, at 7:57 AM, Tim Bunce wrote: Ah, phooey. Guess I'll have to work on finishing the callbaks now ;) W00t! Thanks Steffen. Steffan++; ;-) David

Re: Patch for fetchall_hashref with multiple column key

2005-03-14 Thread David Wheeler
On Mar 14, 2005, at 3:18 PM, Tim Bunce wrote: No, sorry. I abused my position to get fetchall_hashref out sooner 'for work' (which you might have guessed if you noticed the email address of the earlier emails :). It is next on the list though! Understood. I do the same thing all the time for Brico

Re: Patch for fetchall_hashref with multiple column key

2005-03-14 Thread David Wheeler
On Mar 14, 2005, at 12:25 PM, Tim Bunce wrote: DBI 1.48 is out now. I added a t/11fetch.t file with some basic tests. That's the one to patch. Aw, no callbacks yet? ;-) Regards, David

Re: [Fwd: Re: Handle Creation with new_child()]

2005-02-22 Thread David Wheeler
On Feb 22, 2005, at 1:54 AM, Tim Bunce wrote: True. The 'if ref' was a little over the top though. If the user messes with the contents of $h->{Callbacks} then they get what they've asked for. Note that the STORE code for "Callbacks" only gets fired in a few situations. Specifically, doing

Re: [Fwd: Re: Handle Creation with new_child()]

2005-02-21 Thread David Wheeler
On Feb 21, 2005, at 2:17 PM, Tim Bunce wrote: Which is also pretty easily done, eh? Something like this? Yes, though I wouldn't bother validating the contents of the hash. Just checking you're getting a hash ref is enough I think. Well, I figured it was faster to do it up-front (during the constru

Re: Handle Creation with new_child()

2005-02-15 Thread David Wheeler
On Feb 15, 2005, at 2:22 PM, Tim Bunce wrote: I'll drink to that! If you'll be at the MySQL conference in April then I'll be buying. Sadly I won't be going to OSCON this year as it clashes with other commitments. Pity, we'll miss you. I won't be at the MySQL conference. I don't often use MySQL. M

Re: Handle Creation with new_child()

2005-02-15 Thread David Wheeler
On Feb 14, 2005, at 3:09 AM, Tim Bunce wrote: Yes. That much should be trivial for them. The more tricky issue is that it affects how attributes are handles. Currently the drivers connect() method can process the contents of \%attr directly. Many support connect() atributes that are not supported a

Re: [Fwd: Re: Handle Creation with new_child()]

2005-02-15 Thread David Wheeler
On Feb 14, 2005, at 3:14 AM, Tim Bunce wrote: In relation to connect_cached it boiled down to just the difference between: if ($dbh and my $oc = $dbh->{OnConnect}) { $oc->($dbh, $dsn, $user, $pass, $attr) if ref $oc eq 'CODE'; } and: if (my $cb = $dbh->{Callbacks}) { my $oc = $

Re: Handle Creation with new_child()

2005-02-13 Thread David Wheeler
On Feb 13, 2005, at 2:44 PM, Tim Bunce wrote: So, I'm looking at your new_child() stuff, instead. That's a much bigger can of worms! (And one that's hard to tell how deep it is before you really get into it. Driver migration issues may be painful, for example.) Hrm. No :) Having per-class new_child

Re: [Fwd: Re: Handle Creation with new_child()]

2005-02-13 Thread David Wheeler
On Feb 13, 2005, at 2:51 PM, Tim Bunce wrote: Maybe the answer it to not allow changing attributes on a cached handle. That's already the rule and would not change. Er, that's news to me. Uh, sorry, I was thinking of the resetting of AutoCommit. Different applications use handle caching for differ

Re: [Fwd: Re: Handle Creation with new_child()]

2005-02-13 Thread David Wheeler
On Feb 13, 2005, at 5:24 AM, Michael A Chase tech wrote: Does a handle know its cached? Maybe the answer it to not allow changing attributes on a cached handle. That's already the rule and would not change. Regards, David smime.p7s Description: S/MIME cryptographic signature

Handle Creation with new_child()

2005-02-12 Thread David Wheeler
On Feb 12, 2005, at 10:11 AM, Tim Bunce wrote: That's starting to get might complex, isn't it? Uh, "mite". :-) Or "mighty", perhaps. Quite. So, I'm looking at your new_child() stuff, instead. I'm not entirely clear on how to implement it (DBI->connect() seems pretty complex--necessary?), but it s

Re: Callbacks

2005-02-11 Thread David Wheeler
On Feb 4, 2005, at 10:38 AM, David Wheeler wrote: That's starting to get might complex, isn't it? Uh, "mite". :-) D smime.p7s Description: S/MIME cryptographic signature

Re: Callbacks

2005-02-04 Thread David Wheeler
On Feb 4, 2005, at 2:08 AM, Tim Bunce wrote: One way I'd had in the back of my mind way to use the DBI dispatcher to fire the callbacks. $h->{Callbacks}->{$method_name} = \&foo; # called on entry $h->{Callbacks}->{$method_name} = [ \&foo, \&bar ]; # foo on entry, bar on exit $h->{Callback

Re: AutoCommit and connect_cached()

2005-02-03 Thread David Wheeler
e checking for a callback every time the method is called when most people won't use it at all? I don't think I see a way around that, though... Regards, David -- David Wheeler President, Kineticode, Inc. http://www.kineticode.com/ Kineticode. Setting knowledge in motion.[sm] smime.p7s Description: S/MIME cryptographic signature

Re: AutoCommit and connect_cached()

2005-02-03 Thread David Wheeler
On Feb 3, 2005, at 7:45 AM, Tim Bunce wrote: I must still be missing something... Er, why? Sorry, I kept forgetting that DBI::connect_cached() calls DBI::connect(), which calls DBI::_::dr::connect_cached(), which calls (if it finds no dbh in the cache) connect(). The part I kept missing was that

Re: AutoCommit and connect_cached()

2005-02-02 Thread David Wheeler
On Feb 2, 2005, at 10:50 AM, David Wheeler wrote: Yes, quite. I just tested this and it worked great for me (Though it still always returns a new handle for DBD::SQLite for some reason...): Bah! Matt, please ignore my bitching about DBD::SQLite dbhs not getting properly cached. It was because I

Re: AutoCommit and connect_cached()

2005-02-02 Thread David Wheeler
On Feb 2, 2005, at 2:59 AM, Tim Bunce wrote: Try DBI->connect_cached which calls DBI->connect which does: unless ($dbh = $drh->$connect_meth($dsn, $user, $pass, $attr)) { ... } ... if (%$attr) { ... my $a; foreach $a (

Re: AutoCommit and connect_cached()

2005-02-01 Thread David Wheeler
On Feb 1, 2005, at 2:44 AM, Tim Bunce wrote: Depends what you mean by wrong. I don't see any 'bugs' here. No, I wouldn't call it a bug, but it was unexpected behavior (for me, at least). DBI->connect and connect_cached both explicitly set any supplied attributes plus some implicit defaults like P

AutoCommit and connect_cached()

2005-01-31 Thread David Wheeler
Fellow DBIers, This script reveals two issues, one with DBD::SQLite and one with the DBI itself: #!/usr/bin/perl use strict; use DBI; my $dbh = DBI->connect_cached('dbi:SQLite:dbname=test.db', {RaiseError => 1 }); $dbh->begin_work; print "SQLite $dbh: $dbh->{AutoCommit}\n"; $dbh = DBI->connect_c

Re: DBD::Pg vs Pg

2004-12-17 Thread David Wheeler
On Dec 17, 2004, at 12:29 PM, Jochen Wiedmann wrote: Good heavens, is that a difference? Yes. perldoc perlunicode. Regards, David

Re: DBD::Pg vs Pg

2004-12-17 Thread David Wheeler
On Dec 17, 2004, at 3:20 AM, Tim Bunce wrote: imp_dbh->pg_enable_utf8 defaults to off. Ah, good. I assure you that we'll be happy to deprecate it and eventually dump it once DBI has full UTF-8 (and, specifically, utf8) support. Cheers, David

Re: DBURL name scheme

2004-11-29 Thread David Wheeler
On Nov 29, 2004, at 2:46 PM, Hans Schou wrote: But making dbi:// a default prefix will probably restrict the use of DBURL to only DBI. It is not realistic to think that MySQL and PostgreSQL would implement such a naming scheme, where as the original idea might be accepted. It'd be a cinch for the d

Re: Suggestion - use gmail accounts for receiving bug reports, etc.

2004-10-22 Thread David Wheeler
On Oct 21, 2004, at 11:05 PM, Jonathan Leffler wrote: If any driver writer doesn't have a Gmail account already and wants one for this purpose, then I have 4 invitations which I'd donate to the cause. I have six. Email me privately. David

Re: UTF-8 flags (again)

2004-09-08 Thread David Wheeler
On Sep 8, 2004, at 12:58 PM, Tim Bunce wrote: That's the trivial bit :) The fiddly bit is handling the SetUTF8 attribute (and corresponding bit flags to make it fast enough). But thanks anyway :) Ah well, sorry I can't be more help... Regards, David

Re: UTF-8 flags (again)

2004-09-08 Thread David Wheeler
On Sep 8, 2004, at 4:45 AM, Tim Bunce wrote: I was thinking of doing at least "0" on that list for DBI 1.44. I'd especially like to do $dbh->{SetUTF8} = 2; And be done with it. I'll take a look. Patches welcome, of course! Hey, if I knew any C...I can paste these from Encode.xs, at least: _utf8_o

Re: UTF-8 flags (again)

2004-09-07 Thread David Wheeler
On Sun, 08 Aug 2004 12:33:22 -0700, Tim Bunce wrote: I'm thinking in terms of something like $sth->{SetUTF8}->[$index] = $mode 0: Force SvUTF8_off regardless undef: Do nothing (leave it up to the driver) 1: (value is well-formed utf8) ? SvUTF8_on : SvUTF8_off

Re: Solution for the MakeMaker question

2004-09-04 Thread David Wheeler
On Sep 4, 2004, at 2:32 AM, Matt Sergeant wrote: I thought 'use lib' (or perl's require internals) fixed this stuff up internally anyhow? Oh! CAVEATS In order to keep lib.pm small and simple, it only works with Unix filepaths. This doesn't mean it only works on Unix, but non-Unix

Re: Solution for the MakeMaker question

2004-09-03 Thread David Wheeler
On Sep 2, 2004, at 8:58 PM, Darren Duncan wrote: In order for 'make test' to see a perl module that is being stored under the t/ directory in a Perl module distribution, rather than the lib/ directory with the main modules, I found that adding a simple "use lib 't/';" (or in my case, "use lib 't

Re: UTF-8 flags (again)

2004-08-08 Thread David Wheeler
On Aug 8, 2004, at 10:15 AM, Matt Sergeant wrote: Better IMHO would be an extension to bind_col - it should be trivial to add an attribute in there. The downside being that not many people use bind_col. No, but if it could be integrated with bind_columns(), so that several could be specified at

Re: UTF-8 flags (again)

2004-08-08 Thread David Wheeler
On Aug 8, 2004, at 9:14 AM, Matt Sergeant wrote: i.e. for every fetch call, you need to do: SvUTF8_off(AvARRAY(av)[i]); Now, people using your DBD can decide to upgrade the variable if they wish to, but most people who don't need to will be unaffected. I think that this is fine as long as there'

Re: Minimum dependencies for DBI v2

2004-07-09 Thread David Wheeler
On Jul 9, 2004, at 6:41 AM, Jochen Wiedmann wrote: As I've said previously, DBI v2.0 is mainly about changes to the DBI<->DBD interface. Makes no difference, IMO. DBD authors have the same choice to stick with v1 or not. It seems to me that development of v2.0 could perhaps target Perl 5.8. Once

Re: DBI Driver Developers BoF at OSCON?

2004-07-05 Thread David Wheeler
On Jul 5, 2004, at 12:45 PM, Tim Bunce wrote: Are any/many driver authors/maintainers/patchers going to OSCON this year? Any interest in a DBI Driver Developers BoF at OSCON? Main topics would be: Migration to DBI v2 Unified test suite I'm only peripherally involved in DBD::Pg dev

Re: ANNOUNCE: DBI 1.43 release candidate 2 for testing

2004-07-02 Thread David Wheeler
On Jul 2, 2004, at 10:50 AM, David Wheeler wrote: A second release candidate for DBI 1.43 is available for testing at: http://homepage.eircom.net/~timbunce/DBI-1.43-rc2-20040702.tar.gz All tests successful, 9 tests and 110 subtests skipped. Files=39, Tests=2023, 7 wallclock secs ( 5.94 cusr

Re: ANNOUNCE: DBI 1.43 release candidate 2 for testing

2004-07-02 Thread David Wheeler
On Jul 2, 2004, at 5:50 AM, Tim Bunce wrote: A second release candidate for DBI 1.43 is available for testing at: http://homepage.eircom.net/~timbunce/DBI-1.43-rc2-20040702.tar.gz All tests successful, 9 tests and 110 subtests skipped. Files=39, Tests=2023, 44 wallclock secs (11.37 cusr + 2.03 c

Re: Mark II (was: proposed perform_transaction() method)

2004-03-31 Thread David Wheeler
On Mar 31, 2004, at 1:20 PM, Tim Bunce wrote: + $attr->{OnCommit}->() if $attr->{OnCommit}->(); I think you meant: $attr->{OnCommit}->() if $attr->{OnCommit}; Regards, David

Re: ANNOUNCE: DBI 1.42 release candidate 4 for testing

2004-03-14 Thread David Wheeler
On Mar 13, 2004, at 1:20 PM, Tim Bunce wrote: So... I'd appreciate it if people could send me reports of success or failure when *building* a driver *after installing* DBI 1.42. All tests pass for DBD::Pg from CVS. Regards, David

Re: ANNOUNCE: DBI 1.42 release candidate 4 for testing

2004-03-12 Thread David Wheeler
On Mar 12, 2004, at 9:43 AM, David Wheeler wrote: But I'm going to report the @INC issue as a bug for Test::Harness. Done: http://rt.cpan.org/Ticket/Display.html?id=5649 Regards, David

Re: ANNOUNCE: DBI 1.42 release candidate 4 for testing

2004-03-12 Thread David Wheeler
On Mar 12, 2004, at 5:21 AM, Tim Bunce wrote: And another: http://homepage.eircom.net/~timbunce/DBI-1.42-rc4-20040312.tar.gz I hope this is the last release candidate (knowing full well that by saying that I'm tempting fate :) I won't say that this time :) I've changed the t/50dbm.t test t

Re: ANNOUNCE: DBI 1.42 release candidate 2 for testing

2004-03-11 Thread David Wheeler
On Mar 11, 2004, at 4:01 PM, Tim Bunce wrote: And another: http://homepage.eircom.net/~timbunce/DBI-1.42-rc3-20040311.tar.gz All tests pass here: This is perl, v5.8.3 built for darwin-2level This is perl, v5.8.2 built for i686-linux Waiting to hear from Andy Lester about Test::Harness adding

Re: ANNOUNCE: DBI 1.42 release candidate 2 for testing

2004-03-11 Thread David Wheeler
On Mar 11, 2004, at 3:38 PM, Tim Bunce wrote: Please hack on t/50dbm.t to print @INC: - before it's edited in the BEGIN block - after it's edited in the BEGIN block - and before the script exits. If you see .../5.6.1/i386-freebsd appear, which it ought to somewhere, then keep hacking to narrow

Re: ANNOUNCE: DBI 1.42 release candidate 2 for testing

2004-03-11 Thread David Wheeler
On Mar 11, 2004, at 8:56 AM, David Wheeler wrote: t/50dbmParameterless "use IO" deprecated at /usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/BerkeleyDB.pm line 24 t/50dbmok 132/132Undefined subroutine &BerkeleyDB::Term::close_everything called

Re: ANNOUNCE: DBI 1.42 release candidate 2 for testing

2004-03-11 Thread David Wheeler
On Mar 11, 2004, at 8:26 AM, Tim Bunce wrote: A release candidate is available for testing at: http://homepage.eircom.net/~timbunce/DBI-1.42-rc2-20040311.tar.gz All tests pass here: This is perl, v5.8.2 built for i686-linux This is perl, v5.8.3 built for darwin-2level But of course I still get

Re: ANNOUNCE: DBI 1.42 release candidate for testing

2004-03-11 Thread David Wheeler
On Mar 11, 2004, at 1:59 AM, Tim Bunce wrote: Note that .../5.6.1 and .../5.005 don't have .../i386-freebsd as well. Right, because those aren't compiled (XS) modules. I think the bug here is that BerkeleyDB got installed into a non-arch specific directory even though it's a compiled extension. Y

Re: ANNOUNCE: DBI 1.42 release candidate for testing

2004-03-10 Thread David Wheeler
On Mar 10, 2004, at 12:33 PM, Tim Bunce wrote: What does "perl -V" report? sahlins% perl -V Summary of my perl5 (revision 5.0 version 8 subversion 2) configuration: Platform: osname=freebsd, osvers=4.8-stable, archname=i386-freebsd uname='freebsd sahlins.kineticode.com 4.8-stable freebsd

Re: ANNOUNCE: DBI 1.42 release candidate for testing

2004-03-10 Thread David Wheeler
On Mar 10, 2004, at 10:39 AM, Tim Bunce wrote: Any idea why your perl v5.8.2 has .../5.6.1/... in its @INC? Could it be because site_perl should have pure Perl modules in it, and so they should always work for later versions of Perl? I don't know the answer, really; it was put into @INC when I b

Re: ANNOUNCE: DBI 1.42 release candidate for testing

2004-03-09 Thread David Wheeler
On Mar 9, 2004, at 10:21 AM, Jeff Zucker wrote: Thanks much for your tests, David. I'm wondering if the mismatch between your reported perl version 5.8.2 and the location of BerkeleyDB in a 5.6.1 directory has something to do with the results? Ah, yes, curious. I didn't even know that was insta

Re: ANNOUNCE: DBI 1.42 release candidate for testing

2004-03-09 Thread David Wheeler
On Mar 9, 2004, at 7:16 AM, Tim Bunce wrote: A release candidate is available for testing at: http://homepage.eircom.net/~timbunce/DBI-1.42-rc1-20040309.tar.gz All tests pass here: This is perl, v5.8.2 built for i686-linux This is perl, v5.8.3 built for darwin-2level I get failures on FreeBSD

Re: ANNOUNCE: DBI 1.41 release candidate 2 for testing

2004-02-23 Thread David Wheeler
On Feb 23, 2004, at 6:47 AM, Tim Bunce wrote: Groan. 5.9.1 is being, er, clever with version numbers I expect that this is thanks to John Peacock's version.pm. Regards, David

Re: ANNOUNCE: DBI 1.41 release candidate 2 for testing

2004-02-22 Thread David Wheeler
On Feb 22, 2004, at 11:29 AM, Tim Bunce wrote: A second release candidate is available for testing at: http://homepage.eircom.net/~timbunce/DBI-1.41-rc2-20040222.tar.gz All tests pass on the following Perls/platforms: v5.8.3 built for darwin-2level v5.8.2 built for i386-freebsd v5.8.2 built fo

Re: DBI source code now under Subversion: http://svn.perl.org/modules/dbi/

2004-02-01 Thread David Wheeler
On Feb 1, 2004, at 4:44 AM, Tim Bunce wrote: The DBI source code is now hosted under Subversion at http://svn.perl.org/modules/dbi/ Hrm, authorization required... (Many thanks to the unsung heroes at perl.org, especially Robert Spier and Ask Bjørn Hansen, for setting this up.) Yay Robert & Ask!!

Re: DBI source code under perforce soon

2004-01-30 Thread David Wheeler
On Jan 30, 2004, at 2:15 PM, Tim Bunce wrote: If you want to be sent email whenever the DBI source code is changed, send an email to [EMAIL PROTECTED] in order to subscribe to the dbi-changes mailing list. I thought it was going to be Subversion David

Re: OS 10.3 (Panther) - Perl 5.8.1 - DBD::Pg error?

2003-11-04 Thread David Wheeler
output of `make test TEST_VERBOSE`. Thanks, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://www.kineticode.com/ Yahoo!: dew7e Jabb

Re: bytea escaping?

2003-10-09 Thread David Wheeler
bind_param() is 'sticky' and so applies to the later execute(). Oh really? DBI is so cool! Thanks Tim! David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://www.kineticode.com/

Re: bytea escaping?

2003-10-08 Thread David Wheeler
ent with bind_param(), and then call execute() without any arguments. HTH, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://www.kineticode.com/ Yahoo!: dew7e

Re: bytea escaping?

2003-10-08 Thread David Wheeler
. You need to use the PG_BYTEA constant to get DBD::Pg to escape it for you; don't escape it yourself: $rv = $sth->bind_param($param_num, $bind_value, { pg_type => DBD::Pg::PG_BYTEA }); Regards, David -- David Wheeler

Re: Announce: DBI 1.38 release candidate

2003-08-21 Thread David Wheeler
oid. Ah, okay, as long as there's no harm. I'll look at upgrading to gcc 3.3. Regards. David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://www.kineticode.com

Re: Announce: DBI 1.38 release candidate

2003-08-20 Thread David Wheeler
On Wednesday, August 20, 2003, at 03:44 PM, Bjoern Kriews wrote: On Wednesday, August 20, 2003, at 11:45 PM, David Wheeler wrote: Yes, but there are still the other ones: > cc1: warning: changing search order for system directory "/usr/local/include" > cc1: warning: as it

Re: Announce: DBI 1.38 release candidate

2003-08-20 Thread David Wheeler
able `Perl___notused' DBI.xs: In function `log_where': DBI.xs:1783: warning: unused variable `Perl___notused' DBI.xs: In function `XS_DBI_dispatch': DBI.xs:2543: warning: unused variable `Perl___notused' DBI.c: In function `dbih_make_com': DBI.xs:721: warning: `memzero_size

Re: Announce: DBI 1.38 release candidate

2003-08-20 Thread David Wheeler
be used uninitialized in this function DBI.c: In function `dbih_sth_bind_col': DBI.xs:610: warning: `sv' might be used uninitialized in this function DBI.c: In function `dbih_getcom': DBI.xs:610: warning: `sv' might be used uninitialized in this function DBI.c: In func

Re: mod_perl + Apache 1.3.28

2003-08-15 Thread David Wheeler
de of DBD::Pg that was causing the db handle to get corrupted?' And is there some way to clean up after that? That would be great ;) -- All I meant was that I had not added that item to the TODO file :) begin_work() is in there. David -- David Wheeler AIM

Re: mod_perl + Apache 1.3.28

2003-08-15 Thread David Wheeler
On Thursday, August 14, 2003, at 12:53 PM, David Wheeler wrote: Switching to connect_cached() seems to have made my problem with Apache 1.3.28 go away Yay! Did I say this? It's back today! :-( Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at

Re: mod_perl + Apache 1.3.28

2003-08-15 Thread David Wheeler
my problem I'm doubly thankful! Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://www.kineticode.com/ Yahoo!: dew7e Jabb

Re: mod_perl + Apache 1.3.28

2003-08-14 Thread David Wheeler
2:10 PM, Rudy Lippan wrote: here is a patch that gives some more info on what is going on in ping(): Applied, compiled, and installed. Attached are the results (with DBI->trace(9), too). Note that it looks like begin is failing. What might cause that to happen? Regards, David -- Da

Re: mod_perl + Apache 1.3.28

2003-08-14 Thread David Wheeler
I'll add it to my own personal todo list! ;-) Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://www.kineticode.com/ Yah

Re: mod_perl + Apache 1.3.28

2003-08-14 Thread David Wheeler
On Thursday, August 14, 2003, at 11:39 AM, David Wheeler wrote: Caching can be useful in some applications, but it can also cause problems and should be used with care. The exact behaviour of this method is liable to change, so if you intend to use it in any production applications you should

Re: mod_perl + Apache 1.3.28

2003-08-14 Thread David Wheeler
I'm still getting failures. I attach a new log. Look for my comments where the hang occurred, marked by "#" Thanks for the help with this, Rudy! Regards, David -- David Wheeler AIM: dwTheory

Re: mod_perl + Apache 1.3.28

2003-08-14 Thread David Wheeler
hat experimental? Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://www.kineticode.com/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED] Kin

Re: mod_perl + Apache 1.3.28

2003-08-14 Thread David Wheeler
On Wednesday, August 13, 2003, at 12:32 PM, David Wheeler wrote: I'm attempting to isolate the problem now. The code that's causing the hangup looks like this: our $dbh; sub _connect { eval { warn "$$: Checking for DB handle.\n"; unless ($dbh && $d

Re: mod_perl + Apache 1.3.28

2003-08-14 Thread David Wheeler
/lib/Bric/Util/DBI.pm:961] [/usr/local/bricolage/lib/Bric/App/CleanupHandler.pm:131] I have no idea why it was trying to rollback there. It was hung there, and when I cancelled the request from my browser, it didn't log a

Re: mod_perl + Apache 1.3.28

2003-08-14 Thread David Wheeler
On Wednesday, August 13, 2003, at 01:24 PM, Perrin Harkins wrote: On Wednesday, August 13, 2003, at 12:32 PM, David Wheeler wrote: The code that's causing the hangup looks like this: First, we all need to yell at you for not using Apache::DBI. Your code is not doing anything that it doesn

Re: DBI + Apache 1.3.28

2003-07-28 Thread David Wheeler
On Monday, July 28, 2003, at 03:39 PM, Johan Schoen wrote: David Wheeler reported problems with DBI on Apache 1.3.28 and wanted to know if someone else had problems. I have no problems with DBI 1.37, DBD::ODBC 1.06 (with minor changes to Makefile.PL to make it compile) and SAP DB 7.4.3.25 on

DBI + Apache 1.3.28

2003-07-24 Thread David Wheeler
d the problem on FreeBSD and on Mac OS X, and I had a report of the problem on Solaris, so I'm reasonably sure it's not an OS issue. If anyone has this type of problem with other databases, then we can likely eliminate DBI or DBD::Pg as being part of the problem. Many thanks, David -

Re: DBD::Pg via cpan

2003-07-13 Thread David Wheeler
ds, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://kineticode.com/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED] Kineticode. Setting kn

Re: Announce: DBD::Pg 1.30_2 (beta)

2003-06-12 Thread David Wheeler
I'm seeing some errors appearing in my Apache log under Bricolage. Not sure what the deal is, but this didn't happen under DBD::Pg 1.22 or earlier: WARNING: BEGIN: already a transaction in progress WARNING: COMMIT: no transaction in progress WARNING: BEGIN: already a transaction in progress W

Re: [Dbdpg-general] Re: Announce: DBD::Pg 1.30_2 (beta)

2003-06-11 Thread David Wheeler
On Tuesday, June 10, 2003, at 07:12 PM, Rudy Lippan wrote: Sorry, Tested this time :) Yeah, that did the trick. Getting some warnings during the compile, though. Attached. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED

Re: Announce: DBD::Pg 1.30_2 (beta)

2003-06-10 Thread David Wheeler
4 DBI::END() called at t/Bric/Test/Runner.pm line 0 eval {...} called at t/Bric/Test/Runner.pm line 0 END failed--call queue aborted. Bric::__ANON__('Can\'t locate class method \'DBD::Pg::dr::disconnect_all\' vi...') called at t/Bric/Test

Re: [Dbdpg-general] Re: Announce: DBD::Pg 1.30_2 (beta)

2003-06-10 Thread David Wheeler
x27;(' token dbdimp.c: In function `dbd_bind_ph': dbdimp.c:857: warning: passing arg 2 of `Perl_sv_2pv_flags' from incompatible pointer type David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED]

Re: Announce: DBD::Pg 1.30_2 (beta)

2003-06-10 Thread David Wheeler
t /Users/david/Desktop/DBD-Pg-1.30_2/blib/lib/DBD/Pg.pm line 12. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://kineticode.com/

Re: DBD::Pg 1.30_1 WAS (Re: [INTERFACES] Prepare and prepare ?)

2003-05-30 Thread David Wheeler
is to catch them: open STDERR, "| perl -ne 'print unless /: NOTICE: /'" or die "Cannot pipe STDERR: $!\n"; Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED]

Re: DBD::Pg 1.30_1 WAS (Re: [INTERFACES] Prepare and prepare ?)

2003-05-30 Thread David Wheeler
fdefs) Good, nice to have all this centralized. - bind_param() will convert from 1,0 to TRUE/FALSE when pg_type is PGBOOLOID. Nice. - fixed many heap buffer overruns. Thanks Rudy, sounds great! David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED]

Fwd: Bug in DBD::Pg ?

2003-04-03 Thread David Wheeler
on = pg_server_version( $dbh ); should be $version = DBD::Pg::pg_server_version( $dbh ); I received an error on this line when I upgraded from version 1.21 to 1.22. Best regards, Steve _ Stephen Bardsley Senior Engineer -- David Wheeler

Re: [INTERFACES] Prepare and prepare ?

2003-03-26 Thread David Wheeler
On Wednesday, March 26, 2003, at 10:40 PM, Bruce Momjian wrote: OK, release DBD-pg 1.22 uploaded to gborg: I put it on CPAN. Feel free to announce. David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394

Re: [INTERFACES] Prepare and prepare ?

2003-03-26 Thread David Wheeler
over that. Thoughts? Sounds fine to me. David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 Yahoo!: dew7e Jabber: [EMAIL

  1   2   3   >