[exim] exilog query

Kezdőlap
Üzenet törlése
Válasz az üzenetre
Szerző: Jeremy Harris
Dátum:  
Címzett: exim-users
Tárgy: [exim] exilog query
Does this error mean anything to anyone? Tom?

DBD::Pg::st execute failed: ERROR: parser: parse error at or near
"OPTIMIZE" at character 1 at
/usr/local/exilog/bin/../Exilog/exilog_sql.pm line 201.


The routine in question looks like:

sub _pgsql_sql_optimize {
my $where = shift || "nothing";

my $sql = "OPTIMIZE TABLE ".$where;
my $sh = $dbh->prepare($sql);
$sh->execute;
$sh->finish;

return 1;
};



Thanks,
    Jeremy