id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
10655	Post/Page ID Count skips one number when a new page or post created in WordPress 2.8.2	misty9		"The  post or page ID count skips one number whenever a new page or post is created.  

This behavior doesn't occur in WP 2.2.2 where post AND page IDs are sequential. In short, one can easily identify the total number of pages and posts for a given website  by looking at the ID numbers. 

I've notices that after creating a page with ID 25, the next post I had created was given an ID 27, this pattern repeats itself whenever more pages and post are created. In other words, one number is kind of wasted. 

Here are my question:

1. Isn't there a better way in SQL to wisely handle the skipped post ID's? 

2. Why doesn't this cumbersome issue found in WP 2.2.2?


-----------------------------------------------------------
SELECT id, post_title, post_status, post_parent
FROM wp_posts;

                       ID    Post_title                Post_status       Post_parent
			25	Aug 19 test page	publish	0
			26	Aug 19 test page	inherit	25
			27	post test	publish	0
			28	post test	inherit	27
			29	test2	publish	0
			30	test2	inherit	29
			31	post Aug 19, 2009	publish	0
			32	post Aug 19, 2009	inherit	31
-----------------------------------------------------------

I have both WP 2.2.2 and 2.8.2 databases ready for your research if needed."	defect (bug)	closed	low		General	2.8.2	minor	invalid