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"