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 tell how Perl will take the $ at any point in the flow. Or what about later when any language/system that uses $ for special purposes uses your name. Will it take it as a literal $ or for whatever it uses $ for. I'd rethink your db naming shema.

But if i try to do this
$dbh->do("create table foo\$bar (id integer);");

$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

google "Execute called with an unbound placeholder"

Reply via email to