Is it ok to edit post_name in the Wordpress database?

[Shock]

I want to use the name based URL structure but i've got a small problem:

Due to me editing posts and the post_name data remaining the same afterwards, I've got mismatched URLs.

For example: http://mysite.com/2006/12/12/hello-world/ is the URL for the first post. But this post is no longer the "Hello world" one.

Is it ok to just manually go into the database edit the entry, or could this cause some problems?

Thanks.

 

[suarve]

If you change URI structure in the wordpress options i'd assume all posts should update to reflect that structure.

 

[Shock]

That's the problem, they don't.

The database contains post_title and post_name. If I edit a post in Wordpress it will update post_title in the database but not post_name.

Wordpress seems to get the data for the URL from post_name which causes this problem, since I've edited posts!

I've just changed one and everything seems ok, but would be good if someone could confirm it won't cause any problems.