I also gave this issue some thought a while ago. Say, I have a table
event:
db.define_table('event',
db.Field('event'),
migrate='event.table')
after creation it has two columns: event.id and event.event. event.id
is incremented every time I insert an event. Over time events get
deleted. On a small scale this is what happens. I inserted 10 event
and removed the events with event.id 6 and event.id 9. So, in my db I
have 8 events:
event.id event.event.
1 demo
2 course
3 trip
4 ...
5 ...
7 ...
8 ...
10 ...
Now when I insert a new event it gets id 11. The question is, is it
possible to give the new event id 6 instead of 11, and when I insert
two more events, give the second event id 9 and the third event id 11.
As I said, I gave this some thought, in Postgres the sequences are set
to a maximum of 9223372036854775807, so I don't think there is a need
to fill the gaps.
Annet.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
