[OSM-dev] Osmosis and Postgresql

Tom Hughes tom at compton.nu
Wed Jul 8 09:31:05 BST 2009


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 (tom at compton.nu)
http://www.compton.nu/




More information about the dev mailing list