Subject: | Placeholder Bug in DBD::Pg 1.49 |
Date: | Tue, 12 Feb 2008 14:04:38 -0500 |
To: | bug-DBD-Pg [...] rt.cpan.org |
From: | "Robert Landrum" <robertlandrum [...] gmail.com> |
I've attached a script that details the problem with placeholders in
DBD::Pg 1.49 as compiled against PostgresQL 8.2.4.
Basically
SELECT * FROM table WHERE field ~ '^regex';
is fast and
SELECT * FROM table WHERE field ~ ?;
is very very slow.
The server side is 8.2.4 as well. This problem only recently
presented itself when we upgraded the client side libs (and recompiled
DBD::Pg) from PostgresQL 7.4. Prior to that, placeholders in regex
fields worked fine. I have not experienced any issue with other types
of placeholders (i.e. WHERE foo = ? or bar in(?)).
Rob
Message body is not shown because sender requested not to inline it.