Hello,
It looks as if the latest SVN versions are using an SQL command,
"SAVEPOINT", which was introduced after PostgreSQL 7.4. Is DBMail
officially dropping support of the 7.4 version of PostgreSQL?
May 8 11:47:59 www dbmail/lmtpd[3407]: dbpgsql.c,db_query: executing
query [SAVEPOINT header_cache]
May 8 11:47:59 www dbmail/lmtpd[3407]: dbpgsql.c, db_query: Error
executing query [SAVEPOINT header_cache] : [ERROR: syntax error at or
near "SAVEPOINT" at character 1 ]
There are tons of failures after this, with the code trying to roll back
to the save point (which doesn't exist of course), etc. The end result
is the e-mail getting bounced for the user not existing.
<[EMAIL PROTECTED]>: host localhost[127.0.0.1] said: 511 Recipient
<[EMAIL PROTECTED]> Permanent Failure Address Status Bad destination
mailbox address (in reply to end of DATA command)
Perhaps there could be somesort of version check on program start to
warn of an unsupported database?
If you want the full logs, just let me know.
Thanks.
--
Steve Cox
Linux User #365987
www.stevecox.us