duplicate sequence, it is possible? - Mailing list pgsql-general

From Anibal David Acosta
Subject duplicate sequence, it is possible?
Date
Msg-id 001b01cc7667$2f956250$8ec026f0$@devshock.com
Whole thread Raw
Responses Re: duplicate sequence, it is possible?
List 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!

 

pgsql-general by date:

Previous
From: Toby Corkindale
Date:
Subject: Re: PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4
Next
From: Venkat Balaji
Date:
Subject: Re: warm standby - apply wal archives