Quoting backticks

I can not manage to get strings with backtick characters into a
postgres database using the DBD:Pg module. I've tried using the
built in quote method and escaping the backticks with a
regex.. still no joy.

Am I missing something? Is this a bug? Is it with DBD:Pg, DBI or
Postgres itself?

Code snippet follows.. all replies appreciated.

-darrell golliher

This is an except from a CGI program. If one of the form parameters
contains a backtick, then the update fails. Otherwise updates are
successful. Since everybody hitting my application wants to type
contractions like "can't", " won't", and "shouldn't" the script fails
a lot. :(

my $hacks = $hackday_dbh->quote(param('hacks'));
my $schedule = $hackday_dbh->quote(param('schedule'));
$schedule =~ s/'/\'/g;
my $stuff = $hackday_dbh->quote(param('stuff'));
my $shout = $hackday_dbh->quote(param('shout'));
my $attending = $hackday_dbh->quote(param('attending'));

my %cookiedata = cookie('coewos');
my $userid = $cookiedata{'userid'};

my $query = "update data SET shout='$shout',hacks='$hacks',schedule='$schedule',attending='$attending',stuff='$stuff' where email ~* '$userid'";
my $sth = $hackday_dbh->prepare($query);
$sth->execute;