On 08/07/09 09:10, Richard Fairhurst wrote: > Slightly oddly, I also find that when I create a new user, it has id 1, > whereas I'd have expected it to be maximum user id plus one.
Postgres uses proper sequences to do the allocation and a newly created sequence starts at one. MySQL used to give the behaviour you describe because it does auto-increment columns by doing an index lookup to find the highest current value rather than using a proper sequence. Tom -- Tom Hughes ([email protected]) http://www.compton.nu/ _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
