Hello, Yes, drop them and recreate them as:
CREATE INDEX aliases_alias_idx ON aliases(alias); CREATE INDEX aliases_alias_low_idx ON aliases(lower(alias)); And what version of dbmail are you using? I checked 2.0rc4 source before replying to you, and it does not have UNIQUE in there. That needs fixed. Jn ---- Original Message ---- From: Leonel Nunez <[email protected]> To: DBMail mailinglist <[email protected]> Subject: Re: [Dbmail] mail forwarding Sent: Wed, 28 Apr 2004 16:05:41 -0600 > On Wed, 2004-04-28 at 15:46, Jesse Norell wrote: > > > dbmail-adduser -f [EMAIL PROTECTED] [EMAIL PROTECTED] > > > > > > failed check log for details > > > > > > and in the log file: > > > > > > ERROR duplicate key violates unique contraint "aliases_alias_idx" > > > > Drop that unique key. I assume that's something you did yourself, > > not something from dbmail create scripts? > > > > -- > > Jesse Norell > > > this is from : create_tables.pgsql > > CREATE SEQUENCE alias_idnr_seq; > CREATE TABLE aliases ( > alias_idnr INT8 DEFAULT nextval('alias_idnr_seq'), > alias VARCHAR(100) NOT NULL, > deliver_to VARCHAR(250) NOT NULL, > client_idnr INT8 DEFAULT '0' NOT NULL, > PRIMARY KEY (alias_idnr) > ); > CREATE UNIQUE INDEX aliases_alias_idx ON aliases(alias); > CREATE UNIQUE INDEX aliases_alias_low_idx ON aliases(lower(alias)); > > > > so should I drop the 2 indiex ? > > > Leonel > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- End Original Message -- -- Jesse Norell [EMAIL PROTECTED] is not my email address; change "administrator" to my first name. --
