On 23/05/2013 17:57, Tom Hendrikx wrote: > If you check the differences between the 2 mysql files, you'll see that > it only removes the uniqueness on the uid field: usage of the column as > primary key and thus implicit usage of a unique index. > > You can probably make the same trivial changes to the postgresql table > without any troubles.
Did the following on a test database. Seems to work. Not sure if it is correct. First removed the primary key from the table dspam_virtual_uids. ALTER TABLE dspam_virtual_uids DROP CONSTRAINT dspam_virtual_uids_pkey CASCADE; Then removed the index id_virtual_uids_02. DROP INDEX id_virtual_uids_02; Not sure if all of this is correct. Really need advice if this is the correct way to do it. Also noticed that I am not able to add users using Webmin because there is no primary key. For testing, I added users using SQL like the following. INSERT INTO dspam_virtual_uids (uid,username) VALUES (1,'n...@example.com'); Is there a way to add users by using something like dspam_admin? P.V.Anthony ------------------------------------------------------------------------------ Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET Get 100% visibility into your production application - at no cost. Code-level diagnostics for performance bottlenecks with <2% overhead Download for free and get started troubleshooting in minutes. http://p.sf.net/sfu/appdyn_d2d_ap1 _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
