Re: duplicate key violates unique on a nextval() field

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: "Peter Warasin" <peter(at)endian(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: duplicate key violates unique on a nextval() field
Date: 2011-08-30 17:43:35
Message-ID: a744c098-fc31-4ac0-912c-49d09ac241d1@mm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter Warasin wrote:

> The message tells me furthermore that freeradius tries to insert a
> record with a radacctid which already exists.

No, the message you quoted tells about the other unique constraint, the one
named radacct_unique. It's not related to the bigserial primary key.

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Arnold 2011-08-30 17:48:19 pg_upgrade from 8.3.4 issue
Previous Message Rich Shepard 2011-08-30 17:36:54 Re: COPY failure on directory I own [FIXED]