[Bug 7281] New: Incorrect SQL in README.bayes

[bu...@bugzilla.spamassassin.org]

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: dev@spamassassin.apache.org
          Reporter: andrew@topdog.za.net

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.

[Bug 7281] Incorrect SQL in README.bayes

[bu...@bugzilla.spamassassin.org]

https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7281

Giovanni Bechis <gi...@paclan.it> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |giovanni@paclan.it
         Resolution|---                         |FIXED
             Status|NEW                         |RESOLVED

--- Comment #1 from Giovanni Bechis <gi...@paclan.it> ---
Fixed in r1834723, thanks.

-- 
You are receiving this mail because:
You are the assignee for the bug.