[OSM-dev] Osmosis and Postgresql
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 Hughes (tom at compton.nu)
More information about the dev