DB::Introspector V 0.08 MySQL V 4.1.7

2004-11-16 Thread Ron Savage
Ho Folks Anyone using the above combo? What I'm finding is that DB::Introspector is only returning the last of the indexes defined on a table. I believe the problem is where it (DB::Introspector) checks the table comment field looking for /REFER/, which text does not appear with MySQL V

Re: DBD::SQLite bug?

2004-11-16 Thread Matt Sergeant
On 14 Nov 2004, at 23:17, Tim Bunce wrote: On Sun, Nov 14, 2004 at 10:23:07PM +0100, Max Maischein wrote: Tim Bunce wrote: Anyone got an update to this? Nope - http://www.perlmonks.org/index.pl?node_id=404191 points out that the problem also appeared with the MySQL DBD (no version info), but I

DBD-Oracle-1.16 (make error)

2004-11-16 Thread Wikander, Ronald J
Anyone ever receive this error during make? # make cp Oracle.pm blib/lib/DBD/Oracle.pm cp oraperl.ph blib/lib/oraperl.ph cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h cp Oraperl.pm blib/lib/Oraperl.pm cp Oracle.h

Googlebait: Postgres and 'expression too complex'

2004-11-16 Thread Ron Savage
Hi Folks I've encountered an SQL statement like: select x from y where z in (1, 2, ...) and where the () contains about 10,000 numbers of up to 5 digits each, so the entire SQL statement is about 57,000 bytes long. MySQL runs it without error, suggesting a 64 Kb limit on individual statements,

Googlebait: MySQL V 4.0.* 'v' V 4.1.* 'No database selected'

2004-11-16 Thread Ron Savage
Hi Folks Under MySQL V 4.1.* I have found that: $dbh - do('drop database x') $dbh - do('create database x') leads - via DBIx::SQLEngine (at least) - to losing the connexion to the database, so after the drop crete, it is not possible to create tables. The create fails with: Error:

Re: Googlebait: MySQL V 4.0.* 'v' V 4.1.* 'No database selected'

2004-11-16 Thread Tim Bunce
On Tue, Nov 16, 2004 at 08:12:25PM +1100, Ron Savage wrote: Hi Folks Under MySQL V 4.1.* I have found that: $dbh - do('drop database x') $dbh - do('create database x') leads - via DBIx::SQLEngine (at least) - to losing the connexion to the database, so after the drop crete, it is not

Re: DBD-Oracle-1.16 (make error)

2004-11-16 Thread Tim Bunce
On Mon, Nov 15, 2004 at 04:06:37PM -0500, Wikander, Ronald J wrote: Anyone ever receive this error during make? You've not included the information asked for in the README file. But I'd guess that when you ran perl Makefile.PL it said: print

Re: Googlebait: Postgres and 'expression too complex'

2004-11-16 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I've encountered an SQL statement like: select x from y where z in (1, 2, ...) and where the () contains about 10,000 numbers of up to 5 digits each, so the entire SQL statement is about 57,000 bytes long. MySQL runs it without error,

Re: Googlebait: Postgres and 'expression too complex'

2004-11-16 Thread Hardy Merrill
Greg Sabino Mullane [EMAIL PROTECTED] 11/16/04 07:54AM -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Your logic that because it worked, MySQL's limit must be 65kb may be asbogus as the PostgreSQL 32kb logic, but I don't know MySQL well enough to say. Lighten up Greg. Ron did say I

ANNOUNCE: DBI 1.46

2004-11-16 Thread Tim Bunce
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.46.tar.gz size: 372350 bytes md5: 93e00b7a2f6e15a6ea5642b5eb506dba =head2 Changes in DBI 1.46 (svn rev 584),16th November 2004 Fixed parsing bugs in DBI::SQL::Nano thanks to Jeff Zucker. Fixed a couple of bad links in docs thanks to Graham

Perl DBI: Tenth birthday, Roadmap, and Call for Funding

2004-11-16 Thread Tim Bunce
Perl DBI: Tenth birthday, Roadmap, and Call for Funding === *** Birthday *** The first public release of the Perl DBI was ten years ago, on the 12th of October 1994. Those ten years have seen the DBI rapidly become the standard database

Re: Googlebait: Postgres and 'expression too complex'

2004-11-16 Thread Ron Savage
On Tue, 16 Nov 2004 12:54:07 -, Greg Sabino Mullane wrote: Hi Greg  Your logic that because it worked, MySQL's limit must be 65kb may  be as bogus as the PostgreSQL 32kb logic, but I don't know MySQL  well enough to say. Thanx for the info. I did admit I was guessing... -- Cheers Ron

Re: Googlebait: Postgres and 'expression too complex'

2004-11-16 Thread Ron Savage
On Tue, 16 Nov 2004 08:04:06 -0500, Hardy Merrill wrote: Hi Hardy  Lighten up Greg.  Ron did say I admit I'm guessing re the  statement length limits. No offence taken here :-). Sometimes it's necessary to be (a bit) deliberately provocative in order to engender some sort of discussion... --

Re: Googlebait: MySQL V 4.0.* 'v' V 4.1.* 'No database selected'

2004-11-16 Thread Ron Savage
On Tue, 16 Nov 2004 10:42:53 +, Tim Bunce wrote: Hi Tim  That's not really surprising.  You probably just need to $dbh-  do('use database x'); Sure. All I'm saying is that previously 'use' was not required, and I did eventually figure out myself that that would (presumably) fix the

Re: ANNOUNCE: DBI 1.46

2004-11-16 Thread Scott T. Hildreth
With that announcement, lets start a fund drive to DBI Development. I just contributed at, http://dbi.perl.org/donate/ ...so if you have the means to do so, please contribute. Remember it is tax deductible, if you live in the US. STH On Tue, 2004-11-16 at

RE: Perl DBI: Tenth birthday, Roadmap, and Call for Funding

2004-11-16 Thread Tac Tacelosky
What's the address for those of us (for tax reason) who prefer to donate by check? I'll be donating $250, and would (for record-keeping) like the official name of the organization, phone, tax id if it's available, etc. Thanks! Michael Tacelosky -Original Message- From: Tim Bunce

Re: Perl DBI: Tenth birthday, Roadmap, and Call for Funding

2004-11-16 Thread Tim Bunce
On Tue, Nov 16, 2004 at 01:28:24PM -0500, Tac Tacelosky wrote: What's the address for those of us (for tax reason) who prefer to donate by check? Fill in the forms and select Check as the payment type. You'll end up on a page with the address etc. Using the forms means they'll have a record to

RE: Configure DBD::ODBC with DataDirect ODBC drive for Perl

2004-11-16 Thread Jeff Urlwin
All, So far I have perl executable 5.8.0. Do i have to upgrade perl.exe to 5.8.5 version to test DBD::ODBC 1.13 again? No, you shouldn't need to. Regards, Jeff All, I am trying to use Perl with DBI/DBD and Datadirect ODBC to import datafile on unix to remote