On Mar 23, 2005, at 4:57 PM, Greg Sabino Mullane wrote:
This has been fixed in CVS, and will be in 1.41. We hope to release it
in
the next few weeks. Until then, you can specifically bind the parameter
types with bind_param, or you can upgrade your PostgreSQL server (this
bug only affects older
/5.8.0/darwin
/usr/local/lib/perl5/site_perl/5.8.0
/usr/local/lib/perl5/site_perl
.
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://www.kineticode.com/ Yahoo!: dew7e
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
/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/ Yahoo!: dew7e
/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/Runner.pm
line 0
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED
[turnstep]
- Fix binary to a bytea field conversion [Chris Dunlop
[EMAIL PROTECTED]]
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
Yahoo!: dew7e
PROTECTED]
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
Yahoo!: dew7e
Jabber: [EMAIL PROTECTED
that it's not
documented.
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
Yahoo!: dew7e
Jabber: [EMAIL PROTECTED
On Wednesday, February 19, 2003, at 01:03 AM, Ron Savage wrote:
Is there a Postgres DBI/DBD::Pg call which will retrieve the column
attributes the way show columns from $table does under MySQL?
column_info().
http://search.cpan.org/author/TIMB/DBI/DBI.pm#column_info
David
--
David
upgrading).
No, I meant that I used Perl 5.8.0 with iThreads and DBI on Mac OS X
10.1. That's why I recommended the gcc 2.95 compatability mode on
Jaguar, because that's the primary thing that's different in Jaguar.
David
--
David Wheeler AIM: dwTheory
[EMAIL
this, Rudy. I
suspect that once you get this committed, others will contribute, as it
represents the first real advances in DBD::Pg in years. I'll help out
where I can, too.
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED
the ones extraced from pg header files:
grep '^#define'
/data/dnloads/postgresql-7.3/src/include/catalog/pg_type.h
|grep OID pg_typeOID.h
And I think that they should be available to the perl programmer as
well.
Absolutely.
Regards,
David
--
David Wheeler AIM
planning to break the backwards
compatibility of the UTF-8 patch. ;-)
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
Yahoo!: dew7e
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
Yahoo!: dew7e
Jabber: [EMAIL PROTECTED]
Kineticode. Setting knowledge in motion
*inside* the database, so it seems rather crazy that you'd need to use
DBI to talk to the database...
I suggest you post your question to the pgsql-general list, where
there's likely to be more people with PL/Perl experience.
HTH,
David
--
David Wheeler AIM
on your part
Request entered by: DWHEELER (David Wheeler)
Request entered on: Mon, 13 Jan 2003 06:44:57 GMT
Request completed: Mon, 13 Jan 2003 06:46:44 GMT
Virtually Yours,
paused, v89
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED
Lollini --- [EMAIL PROTECTED]
ESPACE Lollini --- www.espacelollini.com
fax: 33 4 93 53 37 90 -- phone: 33 4 93 81 08 69
Official Philatelic Editor of the European Space Agency.
Space stamps and mail for collectors.
--
David Wheeler
On Sunday, December 15, 2002, at 12:05 PM, Tim Bunce wrote:
Try perl -Mblib t/05dbi.t to get more detail.
I think it's actually perl -Ilib t/05dbi.t.
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
environment variables so that they're empty.
HTH,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber
: 'link' : return code '0x460'
Stop.
Does he need some more include-files or any other ideas? Pls help !!!
Strange snprintf is a core function, not part of PostgreSQL or DBD::Pg.
I'm afraid you've reached the limit of my knowledge. Sorry.
David
--
David Wheeler
article will show
you how.
http://www.macdevcenter.com/pub/a/mac/2002/06/07/postgresql.html
I've also posted some instructions on my own site.
http://david.wheeler.net/osx.html
HTH,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED
, and need to be around at
compile time so that DBD::Pg knows what it's going to be loading.
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
these environment variables to each point to a single directory.
HTH,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
}:1407:FATAL:.abort detected. Assembly stopping.
make: *** [dbdimp.o] Error 1
Never seen that before. I build DBD::Pg on Mac OS X, myself. I suggest
you follow Apple's instructions, though.
Sorry,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED
to the
project, get them committed, and then wait for 7.4 to take advantage of
them. Still, it could eventually make such driver metadata requirements
much more portable across later PostgreSQL versions.
Best,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED
for everyone.
Yeah, but it would be a start. Patches warmly welcomed.
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
? Where do you have PostgreSQL installed?
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber: [EMAIL
driver. But for pgperl, you'll have to ask the
PostgreSQL folks. I believe the project is hosted on gborg, though, and
has a mail list.
http://gborg.postgresql.org/project/pgperl/projdisplay.php
HTH,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED
that libs and includes, but it always stops
compiling.
Do you have the PostgreSQL client libraries installed? Are you running
under Cygwin? IIRC, the PostgreSQL client libraries require Cygwin.
HTH,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED
anyway.
Are you sure that Test::More installed properly, and for the same copy
of Perl for which you are also installing DBD::Pg?
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net
.
ERROR: current transaction is aborted, queries ignored until end of
transaction block
Are you using transactions somewhere? Can you send a code snippet that
generates this error?
Thanks,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED
.
I guess this also means that DBD::Pg really needs to be changed to
always detect the version of the database it connects to so that it can
do the right thing. Tim, is there a DBI-standard way to story/provide
an RDBMS version number?
Thanks,
David
--
David Wheeler
.
Thanks,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber: [EMAIL PROTECTED]
developer might like to know about this issue, though, so
that s/he can fix it. Drop 'em an email.
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo
,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber: [EMAIL PROTECTED]
() method. See docs.
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber: [EMAIL PROTECTED]
On Saturday, November 30, 2002, at 03:15 PM, Ian Barwick wrote:
Talking of which, what's the best way of suggesting changes to
documentation?
Create a patch and send it to [EMAIL PROTECTED]
HTH,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED
/15funct.t, a series of tests that determine if the meta
data
is working. [Thomas Lowery]
- Added implementations of column_info() and table_info(), and
primary_key_info(). [Thomas Lowery]
- The POD formatting was cleaned up. [David Wheeler]
- The preparser was updated
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
tests (there's 125 attribue tests now :)
Many thanks for doing this David.
Sure, happy to help.
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net
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
);
$! = 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
?
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber: [EMAIL PROTECTED]
published the first of three articles
discussing Oracle on Mac OS X.
http://www.macdevcenter.com/pub/a/mac/2002/11/12/oracle_part1.html
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http
On Sunday, November 10, 2002, at 05:52 AM, Roderick A. Anderson wrote:
Thanks for the (virtual) slap up along side the head.
Heh, I've been there myself. Don't be too hard on yourself. :-)
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED
direction now.
I'd be interested in seeing a link to the pgsql-general discussion.
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Could not open 'Pg.pm' : No such file or directory at (eval 8) line 6.
[bw@roscoe DBD-Pg-1.13]$
It'd be interesting to know exactly the code that's failing. What's at
line 6?
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED
, there will be a database handle constructor
that will turn this off. But not to redirected it elsewhere, I'm
afraid. Your solution is probably best for now.
HTH,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http
= $@) {
adminmail($err), exec($workdir/msmonbackup.pl);
}
Exceptions are your friends!
HTH,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
On Thursday, October 24, 2002, at 02:06 AM, Stephan Harren wrote:
Does anybody know why DBD:PG make test fails the 04execute test, tests
5-7 ?
Those are designed to be run by the maintainer. Are you setting the
DBDPG_MAINTAINER environment variable?
David
--
David Wheeler
On Monday, October 14, 2002, at 11:30 AM, Hardy Merrill wrote:
Is there an easier way? What am I missing?
Yes, there is: PostgreSQL 7.3. It's still in beta, but should be in
final release soon. It finally adds good ALTER COLUMN support.
HTH,
David
--
David Wheeler
the new column.
HTH,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber: [EMAIL PROTECTED]
On Monday, October 14, 2002, at 11:57 AM, Christopher G Tantalo wrote:
not to be a smart ass(gonna be one anyways), but after all that work,
wouldnt
you want to keep your new column? :)
D'oh!
I mean drop the old column.
David
--
David Wheeler AIM
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber: [EMAIL PROTECTED]
On Tuesday, September 10, 2002, at 02:32 AM, Tim Bunce wrote:
Ping!
Gah! Leave it to me to stick my head out on something like this when
I'm already busy as hell!
I'll try to get something pulled together later this week or early next.
Regards,
David
--
David Wheeler
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
that $Config{perllibs} contains the name of the
directory with your SSL dylds in it.
HTH,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
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
.
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber: [EMAIL PROTECTED]
, 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
-{RaiseError};
Carp::carp ($msg) if $attr-{PrintError};
}
And I attach a new version of the bigger patch that changes all
instances of croak() in connect() to use HandleError if it's present.
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL
. Thoughts?
Thanks,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber: [EMAIL PROTECTED]
DBI.patch
On Wednesday, July 31, 2002, at 04:32 AM, Tim Bunce wrote:
Plus http://search-beta.cpan.org/author/SAMV/Class-Tangram/
Actually, that should be
http://search-beta.cpan.org/author/JLLEROY/Tangram/
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL
.
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber: [EMAIL PROTECTED]
On 7/2/02 1:56 PM, Tim Bunce [EMAIL PROTECTED] claimed:
I hope you don't think I'd actually make a change to the DBI that
would break much old code.
I'd naturally leave finish as a deprecated alias.
Okay. Sanity check. Sorry.
Regards,
David
--
David Wheeler
anyone know how I might suppress these messages using either DBI or
psql?
Thanks,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
On 4/22/02 9:41 PM, Dave K [EMAIL PROTECTED] claimed:
OfCourse posting the error might help
could not connect to server: Connection refused at ./test_pg.pl line 11.
Do you have TCP/IP support enabled for your PostgreSQL database?
Regards,
David
--
David Wheeler
to see DBD::Pg actively maintained
again, since PostgreSQL is a *great* match for Perl projects.
I'll re-send my patch to you under a separate cover.
Thanks,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
Hi All,
I never got a reply from Edmund on this. Does anyone know the status of
DBD::Pg and whether Edmund Mergl still maintains it?
Thanks,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
://www.geocrawler.com/mail/thread.php3?subject=%5BGENERAL%5D+DBD%3A%3APg+BYTEA+Character+Escapinglist=12
Comments are welcome.
Regards,
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
eliminate the
parentheses:
+ return $str if $data_type $no_escape[$data_type];
+ $str =~ s/['\\\0]/$esc{$}/g;
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
with the SQL standards.
David
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
Yahoo!: dew7e
Jabber
people who will want to use this new functionality, as it finally
breaks the 32k row limit for PostgreSQL.
Jeff
--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
On Wed, 14 Mar 2001, Oliver Elphick wrote:
You could write a rule for each table/column that would substitute
NULL for ''.
However, the concept is all wrong. NULL means "I don't know what
this value is". '' means "I know that this value is an empty string".
Furthermore, having NULLs in
Yeah, that's right. There's a place in my application where I can check
every argument passed and change them from empty strings to undef where
relevant, but I'd rather avoid that overhead if there's some sort of
PostgreSQL and/or DBI configuration that'll do it for me.
Thanks!
David
On Wed,
Hi All,
Apologies for cross-posting.
I've ported a mod_perl application from Oracle to PosgreSQL, but have run
into a difference that's significant for web work. When I get a form field
submitted, if it's empty, mod_perl assumes it to be an empty string ('').
When I inserted empty strings into
On 7 Mar 2001, Randal L. Schwartz wrote:
This is weird, but it works:
$rc = $sth-bind_columns(\@column{qw(one two three four five)});
I actually do this all the time with arrays:
$rc = $sth-bind_columns(\@column[0..$#cols]);
Very sweet.
David
77 matches
Mail list logo