主题: postgresql 错误信息
==== 必填信息。没有填写将不予回复 ====
- iRedMail 版本号:0.9.0
- 使用哪个数据库存储用户帐号(OpenLDAP,MySQL,PostgreSQL):Postgresql
- 使用的 Linux/BSD 发行版名称及版本号:Ubuntu-14.0.1
- 与您的问题相关的日志信息:
====
postgresql-9.3-main.log 有大量如下错误信息:
2015-02-09 10:10:50 HKT STATEMENT: SELECT policy_name,message_size_limit
FROM users, policy
WHERE
(users.policy_id=policy.id)
AND (users.email IN ('chihua_huang@sancochip.com', '@sancochip.com', '@.sancochip.com', '@.'))
ORDER BY users.priority DESC
2015-02-09 10:11:14 HKT ERROR: relation "mailaddr" does not exist at character 31
2015-02-09 10:11:14 HKT STATEMENT: SELECT id,priority,email FROM mailaddr WHERE email IN ('@.', 'es@andestech.com', '@andestech.com', '@.andestech.com', '@com', '@.com', '118.163.51.199', '118.163.*.*', '118.163.*.199', '*.*.*.*', '118.163.51.*', '118.*.51.199', '118.*.*.199', '*.*.51.199', '118.*.*.*', '*.163.51.199', '*.*.*.199') ORDER BY priority DESC
2015-02-09 10:11:14 HKT ERROR: relation "users" does not exist at character 61
查看数据表没有mailaddr
晚点再补充