https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7281
Bug ID: 7281
Summary: Incorrect SQL in README.bayes
Product: Spamassassin
Version: SVN Trunk (Latest Devel Version)
Hardware: PC
OS: Mac OS X
Status: NEW
Severity: normal
Priority: P2
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
PostgreSQL sequences do not support Grants to INSERT. Patch attached below to
fix.
diff --git a/sql/README.bayes b/sql/README.bayes
index 273464f..3fde941 100644
--- a/sql/README.bayes
+++ b/sql/README.bayes
@@ -152,7 +152,7 @@ GRANT SELECT, UPDATE, DELETE, INSERT ON TABLE bayes_vars TO
<username>;
GRANT SELECT, DELETE, INSERT ON TABLE bayes_seen TO <username>;
GRANT SELECT, DELETE, INSERT ON TABLE bayes_expire TO <username>;
GRANT SELECT ON TABLE bayes_global_vars TO <username>;
-GRANT UPDATE, SELECT, INSERT ON bayes_vars_id_seq TO <username>;
+GRANT USAGE, SELECT, UPDATE ON SEQUENCE bayes_vars_id_seq TO <username>;
Once you have created the database and added the tables, just add the
required lines to your global configuration file (local.cf).
--
You are receiving this mail because:
You are the assignee for the bug.
