duplicate sequence, it is possible?

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: duplicate sequence, it is possible?
Date: 2011-09-19 00:57:59
Message-ID: 001b01cc7667$2f956250$8ec026f0$@devshock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everyone.

I have a table with a PK, this table has a lot of insert per second (100 ~
150 insert /sec)

Sometimes, a get a duplicate key error, but ID is generated from a function
(VOLATILE). This function has just one line (select nextval('XXX'))

Is possible that this function return same ID for two diff call?

Postgres version is 9.0

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Shepanski 2011-09-19 05:07:20 Re: index row requires 10040 bytes, maximum size is 8191
Previous Message Toby Corkindale 2011-09-19 00:38:25 Re: PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4