david at kineticode
Jul 26, 2010, 3:21 PM
Post #2 of 2
(367 views)
Permalink
|
On Jul 26, 2010, at 2:35 PM, Fletcher, Michael wrote:
> Hello,
>
> We are experiencing gaps between the id's in the member table. The id's are not always sequential. Sometimes the gaps are small, like 3 or 4. Sometimes there are no gaps. Other times we have found large gaps.
>
> In our PostgreSQL sequence setup for that table, it is set to increment by 1. I believe NEXTVAL is used in the Bric pm files, so we are confused about why there would be gaps.
>
> Is anyone else experiencing this?
There might be code to delete member records when an object is removed from a group. Or an ID might be fetched and then the transaction rolled back, which means the ID doesn't get used at all. I wouldn't worry about it.
Best,
David
|
