Re: [Dbmail] mail forwarding

[Leonel Nunez]

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