Home > mailing lists

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

From	Anibal David Acosta
Subject	duplicate sequence, it is possible?
Date	September 19, 2011 01:05:34
Msg-id	001b01cc7667$2f956250$8ec026f0$@devshock.com Whole thread Raw
Responses	Re: duplicate sequence, it is possible? (Alban Hertroys <haramrae@gmail.com>)
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!

From: Toby Corkindale
Date: 19 September 2011, 00:38:35
Subject: Re: PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4

From: Venkat Balaji
Date: 19 September 2011, 05:11:05
Subject: Re: warm standby - apply wal archives