It is not possible and it would be a bad idea to do so.
Massimo
On Jun 20, 10:29 am, annet <annet.verm...@gmail.com> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
