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

From: Peter Warasin <peter(at)endian(dot)com>
To: Daniel Verite <daniel(at)manitou-mail(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: duplicate key violates unique on a nextval() field
Date: 2011-08-30 17:48:28
Message-ID: 4E5D226C.6080702@endian.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi

On 30/08/11 19:43, Daniel Verite 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.

aah, stupid me. thank you!
ok, then back to coova-chilli :)

peter

--
:: e n d i a n
:: security with passion

:: peter warasin
:: http://www.endian.com :: peter(at)endian(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2011-08-30 17:52:25 Re: SELECT Query on DB table preventing inserts
Previous Message Justin Arnold 2011-08-30 17:48:19 pg_upgrade from 8.3.4 issue