Postgres Pro
Downloads
Home   >   mailing lists

Re: duplicate key violates unique on a nextval() field - Mailing list pgsql-general

From Daniel Verite
Subject Re: duplicate key violates unique on a nextval() field
Date
Msg-id a744c098-fc31-4ac0-912c-49d09ac241d1@mm
Whole thread Raw
In response to duplicate key violates unique on a nextval() field  (Peter Warasin <peter@endian.com>)
Responses Re: duplicate key violates unique on a nextval() field
List pgsql-general
Tree view 
    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

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: COPY failure on directory I own [FIXED]
Next
From: Justin Arnold
Date:
Subject: pg_upgrade from 8.3.4 issue