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

Reply via email to