Brian,
If you summarize/resend the patches, preferably with documentation and
patches to the tests to validate the patches, I would be likely to put
them in at least the subversion repository and roll out a proper patch
if things look good.
Jeff
-Original Message-
From: Brian Becker
Hi,
i am using postgresql 7.4.7 on an ubuntu box, perl 5.8.4 and DBI version
1.46 with DBD::Pg version 1.32.
i can create tables from psql with an $ in the middle of it, e.g. create
table foo$bar (id integer);
But if i try to do this
$dbh-do(create table foo\$bar (id integer););
in a script, then
moma wrote:
Hi,
Hello,
i am using postgresql 7.4.7 on an ubuntu box, perl 5.8.4 and DBI version
1.46 with DBD::Pg version 1.32.
i can create tables from psql with an $ in the middle of it, e.g. create
table foo$bar (id integer);
That seems like a bad bad bad bad idea because how can you
Hi,
You should escape the $. For eg, this prints $ literally:
perl -e 'print \$;'
so you could do create table foo\$bar (id integer);
This has got nothing to with dbi.
- Sandeep
On Thu, 2005-09-29 at 16:37 +0200, moma wrote:
Hi,
i am using postgresql 7.4.7 on an ubuntu box, perl 5.8.4
Sandeep Chayapathi [mailto:[EMAIL PROTECTED] wrote:
You should escape the $. For eg, this prints $ literally:
perl -e 'print \$;'
so you could do create table foo\$bar (id integer);
That *is* what he tried to do:
But if i try to do this
$dbh-do(create table foo\$bar (id integer););
oops! Muy Bad! I need more coffee :)
Sorry, I have no solution for this.
- Sandeep
On Thu, 2005-09-29 at 11:12 -0400, Ronald J Kimball wrote:
Sandeep Chayapathi [mailto:[EMAIL PROTECTED] wrote:
You should escape the $. For eg, this prints $ literally:
perl -e 'print \$;'
so you
moma wrote:
Hi,
i am using postgresql 7.4.7 on an ubuntu box, perl 5.8.4 and DBI version
1.46 with DBD::Pg version 1.32.
i can create tables from psql with an $ in the middle of it, e.g. create
table foo$bar (id integer);
But if i try to do this
$dbh-do(create table foo\$bar (id integer););
in
moma wrote:
i believe this is the DBD::Pg driver interpreting the $ as a
placeholder. i think you can surpress placeholder parsing with the
pg_direct attribute eg
$dbh-do(create table foo\$bar (id integer), { pg_direct = 1} );
although i think this is only available in the latest versions of
Hi,
I am running ActivePerl 5.8.7 and MySQL 4.1 on a WindowsXP box. It
won't let me drop or create a table through DBI. My code and error message
are attached.
Thanks
Mary Anderson
David Manura wrote:
SQL-Interpolate 0.31 is now available on CPAN:
http://search.cpan.org/dist/SQL-Interpolate/ . This includes a new
(WHERE, {x = [EMAIL PROTECTED], ...}) syntax, bug fixes, and clarified
documentation. Discussions on the module will now take place on the
CPAN::Forum
Tim Bunce wrote:
I'm interested to hear stories of people who have subclassed the DBI,
or used modules that subclass the DBI.
Just as a simple example, how evil is this?:
package MyDbi;
use base 'DBI';
package MyDbi::db;
use base 'DBI::db';
sub prepare {
my($self,@connect_args) = @_;
Oops, the SUPER::execute() and error check should happen before the
reconstruction:
package MyDbi;
use base 'DBI';
package MyDbi::db;
use base 'DBI::db';
sub prepare {
my($self,@connect_args) = @_;
return bless $self-SUPER::prepare(@connect_args), 'MyDbi::st';
}
package MyDbi::st;
use
Sorry, not enough coffee this morning, I forgot to use the DBD's quote,
dub^9.
package MyDbi;
use base 'DBI';
package MyDbi::db;
use base 'DBI::db';
sub prepare {
my($self,@connect_args) = @_;
return bless $self-SUPER::prepare(@connect_args), 'MyDbi::st';
}
package MyDbi::st;
use base
Hi all,
This is a reposting of a message. I was advised that my attached code
did not make it through.
Basically, I am running ActivePerl 5.8.7 and mySQL 4.1 under windows XP.
Although I can handle data manipulation statements through DBI, it balks
at drop table and create table
- Original Message -
From: Mary Anderson [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Thursday, September 29, 2005 3:00 PM
Subject: Reposting of ActivePerl/MySQL problem dropping tables
Hi all,
This is a reposting of a message. I was advised that my attached code
did not make
On Thu, 29 Sep 2005 13:00:56 -0700 (PDT), Mary Anderson wrote:
Hi Mary
#!C:\perl\bin\perl.exe
use strict;
This is good to add:
use warnings;
use DBI;
open(STDERR, LoadJgan.err);
open(STDOUT, LoadJgan.out);
## Remove any old dbi trace logs
unlink 'dbitrace.log' if -e 'dbitrace.log';
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
i am using postgresql 7.4.7 on an ubuntu box, perl 5.8.4 and DBI version
1.46 with DBD::Pg version 1.32.
...
$dbh-do(create table foo\$bar (id integer););
...
DBD::Pg::db do failed: Execute called with an unbound placeholder
So i want to know,
17 matches
Mail list logo