From: | "Henrik Steffen" <steffen(at)city-map(dot)de> |
---|---|
To: | "Andrew Gould" <andrewgould(at)yahoo(dot)com> |
Cc: | "pgsql" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Cannot create unique index |
Date: | 2003-06-30 13:05:02 |
Message-ID: | 052c01c33f08$37c15050$9800a8c0@henrik |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
yes, of course, I allready did this.
What I was aiming at, was, that postgres
should normally not insert a duplicate value
into a unique index, should it?
Isn't this a bug?
--
Mit freundlichem Gruß
Henrik Steffen
Geschäftsführer
top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------
----- Original Message -----
From: "Andrew Gould" <andrewgould(at)yahoo(dot)com>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>
Sent: Monday, June 30, 2003 2:46 PM
Subject: Re: [GENERAL] Cannot create unique index
> --- Henrik Steffen <steffen(at)city-map(dot)de> wrote:
> >
> > Hello all,
> >
> > REINDEXING a table I get the following message:
> >
> > ERROR: Cannot create unique index. Table contains
> > non-unique values.
> >
> > How can that be in REINDEXING ?
> >
> > This means, that the index has been corrupted
> > before,
> > because the index has always been unique. But
> > somehow
> > the postmaster must have succeeded in inserting a
> > non-unique
> > value anyway.
> >
> > Now the index is corrupted, and I get every 10-15
> > minutes
> > a message, telling me the following:
> >
> > The Postmaster has informed me that some other
> > backend
> > died abnormally and possibly corrupted shared
> > memory.
> > I have rolled back the current transaction and am
> > going to terminate your database system connection
> > and exit.
> > Please reconnect to the database system and repeat
> > your query.
> >
> >
> > Haven't had this for quite a while now (using 7.3.3)
> >
> > Any idea?
> >
> > In my opinion this should not be possible...
> >
> > Henrik Steffen
>
> You might try:
>
> 1. Drop the unique index.
> 2. Perform a query to check for duplicates.
> 3. Remove duplicates, if any.
> 4. Vacuum the table.
> 5. Recreate the unique index.
>
> Best of luck,
>
> Andrew Gould
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2003-06-30 13:30:05 | Re: Making pgsql error messages more developers' friendly. |
Previous Message | Jan Wieck | 2003-06-30 13:02:50 | Re: Making pgsql error messages more developers' friendly. |