Re: CPAN indexer (was Re: DBD::Pg CVS version.)

that are case insensetive (DOS, Mac OS). Unfortunately this same argument goes against similar names like build. So I dont have any better suggestion other than something like privlib. What does CPAN::MakeMaker want to use? David -- David Wheeler AIM: dwTheory

Re: Anybody using $h-event(...) and DBIh_EVENT*() ?

for the undocumented Handlers attribute back in June 2002 - and that was the only way to do anything with $h-event(...) and DBIh_EVENT*(). So all is well. Cool, thanks. David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http

Re: $sel-CursorName does not exist

years ago. IIRC, SQL Server can throw exceptions. Should be very cool, indeed. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: CPAN indexer (was Re: DBD::Pg CVS version.)

On Monday, November 25, 2002, at 03:37 PM, David Wheeler wrote: I'd just hack in the very few alternatives you need (/ + Max + VMS, you can ignore windows as / works fine) in a BEGIN block. Um, what is it on VMS? ...Never mind, I can look in File::Spec::VMS. Or not. Here's what I got: my

Re: Escaping Binary Data in DBD::Pg

On Monday, November 25, 2002, at 03:57 PM, David Wheeler wrote: If it doesn't work then yes (if $h-{Warn} is set, see Driver.xst for examples). Okay, I'll try to work up that patch tonight. Here's the patch. I would appreciate any feedback. I had to alter quote() quite a bit again

Re: Escaping Binary Data in DBD::Pg

, but forgot all about it, borrowing instead from the patch I just sent. Thanks for the tip. I'm committing the enclosed patch. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net

DBD::Pg: Newbie Question

: void pg_notifies(dbh) SV * dbh CODE: D_imp_dbh(dbh); ST(0) = dbd_db_pg_notifies(dbh, imp_dbh); In dbdimpc.c, dbd_db_pg_notifies returns SV *. So, uh, my XS newbie question is, what does this mean? What's the problem? Thanks, David -- David Wheeler

Re: DBD::Pg - a strong request

CPAN will fail. Yes, I'd like to see DBD::Pg start to use a more standard and comprehensive test suite. Needless to say, I plan such a thing for the new version I'm working on. But that's going to be a while in the making... Regards, David -- David Wheeler

Re: Escaping Binary Data in DBD::Pg

, however, and doesn't throw a warning. Should it? Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: CPAN indexer (was Re: DBD::Pg CVS version.)

the side affect that everyone will have CPAN::MakeMaker in thier dist on search. Works for me. How 'bout inc/? David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net

Re: Anybody using $h-event(...) and DBIh_EVENT*() ?

at the point they set err errstr but the DBI never did much with them).\ Naturally, DBD::Pg uses DBIh_EVENT2 in a couple of places: DBIh_EVENT2(h, ERROR_event, DBIc_ERR(imp_xxh), DBIc_ERRSTR(imp_xxh)); But I imagine we can purge these, if necessary. David -- David Wheeler

Re: CPAN indexer (was Re: DBD::Pg CVS version.)

, what is it on VMS? Never mind, I can look in File::Spec::VMS. David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: $sel-CursorName does not exist

reasonably). # When a HandleEvent attribute gets added to the DBI then we'll probably call that # at the moment the error is registered, and so we could test $sth-{Kids} then. Ah, how interesting. Makes sense. Um, what is HandleEvent? Have you described it somewhere? David -- David Wheeler

Re: Patch: HandleError in connect()

); $! = 0; # for the daft people who do DBI-connect(...) || die $!; Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: Escaping Binary Data in DBD::Pg

be inclined to dump it right now. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e Jabber

Re: Escaping Binary Data in DBD::Pg

, it won't just be deprecated, it'll be gone! Either way, the docs will be updated. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: Escaping Binary Data in DBD::Pg

for this together tomorrow. Best, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED]

Re: DBD::Pg CVS version.

On Friday, November 22, 2002, at 11:53 PM, Jason E. Stewart wrote: I'm not sure of the status of this. I believe David was integrating App::Info into a private directory to only be used by the configuration process. Right. I can commit it today if people like. Regards, David -- David

Re: DBD::Pg CVS version.

been added and committed to CVS. -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED]

Re: DBD::Pg CVS version.

be removed as it is not part of DBI nor truly required by the DBD::Pg. FYI, if you set the POSTGRES_INCLUDE and POSTGRES_LIB environment variables, then Makefile.PL won't require App::Info. Regards, David -- David Wheeler AIM: dwTheory [EMAIL

Re: DBD::Pg CVS version.

, maybe it makes more sense. Then we would just use lib 't/lib'; or something, instead of use lib 'inc'; Make sense? David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net

Re: DBD::Pg CVS version.

On Saturday, November 23, 2002, at 01:15 PM, David Wheeler wrote: I'll work at getting all the tests to run properly, and then make a release in a couple of days. Feedback? Yes, the quote issue has to be fixed. I'll try to find some tuits to work on that this weekend. I've started work

Re: Escaping Binary Data in DBD::Pg

that SQL_BINARY doesn't become BYTEA. Then anyone who is binding SQL_BINARY will have to change it. Or we can document that it's *going* to change in the next version -- and maybe throw a warning -- and put it off till the next version. Thoughts? David -- David Wheeler

Re: [INTERFACES] DBD::PostgreSQL

On Wednesday, November 20, 2002, at 11:50 PM, Oliver Elphick wrote: SELECT version(); Right, I've used that before. Too bad it doesn't just return the version number. But I can parse it out. Thanks, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED

Re: [INTERFACES] DBD::PostgreSQL compile time /run time version

be the best reason to change the name of the driver. But I'm still on the fence wrt all this, and it's likely to be months before I have something workable and it's time to decide how to handle the issue of compatibility. Regards, David -- David Wheeler AIM

Re: DBD::PgSQL: More Queestions

. Welcome to this neverending world of tuit shortage :/ Oh man, I've been there for a *while*! I'm just foolish enough to *continue* to put more on my plate. Ah, well! Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED

Re: DBD::PgSQL: More Queestions

this parses out the comments in Perl space. It never even occurred to me that one could use comments in SQL statements sent to DBI. But it does make sense to allow them. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED

Re: :PgSQL: More Queestions

is escaped and string continues... Right...I realized just as I was passing out last night that it would miss-parse terminal escapes. and such. If the original code isn't broken it doesn't need fixing, maybe just commenting. Absolutely. Best, David -- David Wheeler

Re: :PgSQL: More Queestions

in light of Rudy's demonstration of how PostgreSQL 7.3's prepared statements work. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: DBD::PgSQL: More Queestions

a good feature to add later. Thanks Tim. David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e Jabber: [EMAIL

Re: DBD::PgSQL: More Queestions

through 7 to report, say, every function executed? Yeap. (DBD::Oracle uses 9 for that now but I may change it.) Okay, cool. David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net

Re: DBD::PgSQL: More Queestions

to diagnose a problem with the driver. Best, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e Jabber

Re: :PgSQL: More Queestions

I'll keep at it until I feel I understand it as well as I can, and then post my thoughts on what to do next. Thanks, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net

Re: [INTERFACES] DBD::PostgreSQL

On Wednesday, November 20, 2002, at 07:56 AM, Peter Haworth wrote: Fair enough, but at least check the server version on connection, and bail if it's not high enough. What's the easiest way to get the version on connection? Thanks, David -- David Wheeler

Re: [INTERFACES] DBD::PostgreSQL

the 1/0 behavior is most Perlish, I'll stick to that as the default. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

DBD::PgSQL: More Queestions

from. -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED]

Re: [INTERFACES] DBD::PostgreSQL

was really looking forward to the performance boost. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: DBD::PostgreSQL

types are required, as it means that dynamic database clients like DBI (and, I expect, JDBC) won't really be able to take advantage of prepared statements. Only custom code that uses the PostgreSQL API directly (that is, C applications) will be able to do it. Regards, David -- David Wheeler

Re: DBD::PostgreSQL

wants to help other newbies along... Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

DBD::PostgreSQL

would go a long way toward helping me to reach my goal. TIA, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: DBD::Pg Patches

directories are just ignored by ExtUtils::MakeMaker. I know that I had to explicitly tell it to build stuff in a bin directory in one of my other modules. I just realized that these changes will require that we re-create MANIFEST. I'll be sure to do that, too. Regards, David -- David Wheeler

Re: DBD::Pg Patches

I'd prefer to add it back once I've added the new files. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: DBD::Pg Patches

are installed on a system. If people would rather make App::Info a prerequisite for installing DBD::Pg, we could do that, but it seems rather more onerous to me. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ

Re: DBD::Pg Patches

On Monday, November 4, 2002, at 01:50 AM, Jan-Pieter Cornet wrote: CPANPLUS does the same, it comes with ExtUtils::AutoInstall, which is stored in inc/. Just make sure you ``use lib inc'' from Makefile.PL Fine with me. Anyone object? Regards, David -- David Wheeler

Re: Escaping Binary Data in DBD::Pg

bytea type. Right, okay. Thanks for the reply, Tim! Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: DBD::Pg prepqre and quote. (WAS: Re: Escaping Binary Data in DBD::Pg)

. Hopefully I'll have a chance to look at this stuff myself in the not-to-distant future. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Escaping Binary Data in DBD::Pg

dbi-devers, I have some dev-related questions at the end of this message, so please bear with me. :-) On Thursday, October 24, 2002, at 09:54 PM, David Wheeler wrote: The DBI documentation says of quote(): Quote will probably not be able to deal with all pos- sible

Re: [INTERFACES] DBD::Pg and binary data

where such issues fall, I'll ensure that messages are directed to their proper outlets. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: [INTERFACES] DBD::Pg and binary data

. Oh, duh. The proper solution then should have been: while (my $rd = read $fh, $data2, 65536) { $data .= $data2; $datasize += $rd; } $data = $dbh-quote($data); Sorry about that. David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED

Re: [INTERFACES] DBD::Pg and binary data

. In the meantime, though, I welcome feedback on the existing patches: http://gborg.postgresql.org/project/dbdpg/patch/patchlist.php Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net

Re: [INTERFACES] DBD::Pg and binary data

to the appropriate libpq routines. David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED]

Re: [INTERFACES] DBD::Pg and binary data

at the DBD::Pg code, but the XS is a little over my head. Anyone want to provide a patch? Thanks, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: [INTERFACES] DBD::Pg and binary data

); Can you send me the script and the data you're trying to insert? Thanks, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Fwd: DBD::Pg Patches

/Pacific To: David Wheeler [EMAIL PROTECTED] Subject: Re: DBD::Pg Patches Another to add to the list -- \'s were thowing off placeholders --- dbdimp.c.orig Tue Oct 22 16:09:13 2002 +++ dbdimp.cTue Oct 22 16:09:44 2002 @@ -667,8 +667,14 @@ if (in_literal) { /* check

DBD::Pg Patches

at this point, I think it'd make sense to include the relevant classes in the DBD::Pg distribution. Any suggestions on a standard place to put them where make won't install them? Best, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED

Re: [INTERFACES] DBD::Pg and binary data

, Cristóvão? If my patch isn't working, we definitely need to figure something out. Anyway, fixing this bug would be a great goal for the next release ;) Agreed. David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394

Re: DBD:pg outstanding patches

. However, Jeffrey did point out that it might in fact make more sense (and faster) to use the PQescapeString() function in C. Anyone want to volunteer a patch? I can't speak to the other patches, though. Regards, David -- David Wheeler AIM: dwTheory [EMAIL

DBD::Pg Going Forward (Was: DBD::Pg up for sale)

to make DBD::Pg the best written, best-supported DBI driver on the CPAN. Regards, David * This is not intended as a slam against the previous DBD::Pg developers -- hey, we owe it to them that DBD::Pg exists in the first place! Thanks, guys! -- David Wheeler AIM

Re: DBD:pg outstanding patches

and XS to be able to supply patches for such an idea. :-) Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: DBD::Pg Going Forward (Was: DBD::Pg up for sale)

on dbi-dev, I'm reasonable confident that this is exactly what will happen. :-) Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: DBD::Pg up for sale

can send them directly to Bruce [EMAIL PROTECTED], and he'll send them to the list. I've my first project going live on Oct 28 using PostgreSQL, Perl with DBD::Pg, and PHP ... Cool! Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED

Re: DBD::Pg up for sale

. Hell, I can ping Bruce Momjian via IM just about any time. I'm sorry you've had such trouble; I don't think that's a universal experience. Maybe I could help hook you up with Bruce or something? I would offer to take it over, but my knowledge of C and XS is nil. Regards, David -- David

Re: Patch: HandleError in connect()

On Tuesday, September 10, 2002, at 03:17 AM, Tim Bunce wrote: If you can do it cleanly and give me a tested patch then I'd probably find it hard to say no :) I'll work on this later this week, too. Thanks, David -- David Wheeler AIM: dwTheory [EMAIL

Re: Patch: HandleError in connect()

ultimately decide not to do this, I'll go ahead and rip that stuff out. Thanks, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e

Re: Patch: HandleError in connect()

. Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED]

Re: Patch: HandleError in connect()

, then RaiseError and PrintError will not be acted upon... Hmm, good point. What's your call, Tim? Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo

Patch: HandleError in connect()

. Thoughts? Thanks, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED] DBI.patch

Re: Patch: HandleError in connect()

On Thursday, August 22, 2002, at 07:17 AM, David Wheeler wrote: + # XXX add $attr{HandleError} logic here? Yes! +$attr-{HandleError}($msg, $drh, $dbh) + if UNIVERSAL::isa($attr-{HandleError}, 'CODE'); D'oh! Did it again! Here it is with the arrow operator

<    1   2