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 a script, then following error is emiited:
DBD::Pg::db do failed: Execute called with an unbound placeholder
So i want to know, is it a bug or intended for portability?
thanks
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 DBD::Pg.
--
- Rich Doughty
