Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

TeeJay (2309)

TeeJay
  (email not shown publicly)
http://www.aarontrevena.co.uk/

Working in Truro
Graduate with BSc (Hons) in Computer Systems and Networks
pm : london.pm, bath.pm, devoncornwall.pm
lug : Devon & Cornwall LUG
CPAN : TEEJAY [cpan.org]
irc : TeeJay
skype : hashbangperl
livejournal : hashbangperl [livejournal.com]
flickr :hashbangperl [flickr.com]

Journal of TeeJay (2309)

Thursday December 28, 2006
10:48 AM

annoying bugs in DBD::Pg

[ #32010 ]

So I'm minding my own business writing geometric queries and discover that DBD::Pg can't cope with the ?# operator, so I switch look at changing the placeholder format in SQL::Abstract but it doesn't provide a way to do so (mst has offered to look at adding it later if I provide a patch), so I try directly using DBI and find that if I change the placeholders I'm using to $1 format, I get a different error. Joy.

So I install a new version of DBD::Pg, but of course I can't install it via CPAN as it requires env vars be set (not asking for them interactively), and the 00signatures test fails so it won't install, and I have to install it manually.

The new version gives the same error, so I've reported it, and you can find details at http://rt.cpan.org/Ticket/Display.html?id=24124

so, for future reference - you can't use any postgres syntax with ? in, with DBD::Pg, nor install it via cpan.

now to create a function that does in 10 lines what ?# does in 1 :(

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.