On 31/05/2013 11:45, P.V.Anthony wrote: > 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.
Please comment if the above is ok to be done. I am not an expert. Need all the advice I can get before doing it to the live database. P.V.Anthony ------------------------------------------------------------------------------ How ServiceNow helps IT people transform IT departments: 1. A cloud service to automate IT design, transition and operations 2. Dashboards that offer high-level views of enterprise services 3. A single system of record for all IT processes http://p.sf.net/sfu/servicenow-d2d-j _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
