On 31/05/2013 00:17, Nathanael D. Noblet wrote: > I did something similar with mysql, I don't use the admin panel so can't > speak authoritatively but the only thing I didn't see you do was add a > index/unique constraint (could be primary) on the username column.
That did it. Thank you very much for the help. Here is what was done altogether for modifying the current virtual user table in Postgresql. Let me know if this is correct. Please share your advice. 01. Removed the primary key from the table dspam_virtual_uids. ALTER TABLE dspam_virtual_uids DROP CONSTRAINT dspam_virtual_uids_pkey CASCADE; 02. Removed the index id_virtual_uids_02. DROP INDEX id_virtual_uids_02; 03. Added a normal index, not unique index. CREATE INDEX id_virtual_uids_02 ON dspam_virtual_uids(uid); 04. Add primary key to table dspam_virtual_uids but to username. ALTER TABLE dspam_virtual_uids ADD PRIMARY KEY (username); Need advice if this is correct and ok to be used with dspam. P.V.Anthony ------------------------------------------------------------------------------ Get 100% visibility into Java/.NET code with AppDynamics Lite It's a free troubleshooting tool designed for production Get down to code-level detail for bottlenecks, with <2% overhead. Download for free and get started troubleshooting in minutes. http://p.sf.net/sfu/appdyn_d2d_ap2 _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
