Mailing List Archive

Author: parker
Date: Tue Aug 2 18:28:22 2005
New Revision: 227144

URL: http://svn.apache.org/viewcvs?rev=227144&view=rev
Log:
Bug 4510: Add missing UNIQUE index for bayes_vars

Modified:
spamassassin/trunk/sql/bayes_pg.sql

Modified: spamassassin/trunk/sql/bayes_pg.sql
URL: http://svn.apache.org/viewcvs/spamassassin/trunk/sql/bayes_pg.sql?rev=227144&r1=227143&r2=227144&view=diff
==============================================================================
--- spamassassin/trunk/sql/bayes_pg.sql (original)
+++ spamassassin/trunk/sql/bayes_pg.sql Tue Aug 2 18:28:22 2005
@@ -46,7 +46,7 @@
PRIMARY KEY (id)
) WITHOUT OIDS;

-CREATE INDEX bayes_vars_idx1 ON bayes_vars (username);
+CREATE UNIQUE INDEX bayes_vars_idx1 ON bayes_vars (username);

CREATE OR REPLACE FUNCTION put_token(integer, bytea, integer, integer, integer) RETURNS bool AS '
DECLARE