On Wed, 2004-04-28 at 16:05, Leonel Nunez wrote:
> 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
>
>
For your information:
Droped the 2 index and all worked fine
Now I have the [EMAIL PROTECTED] keep and forwarded a copy to
[EMAIL PROTECTED]
Thanks !
Leonel
