[web2py] Re: Changing an id... could it be really bad?

2011-05-31 Thread Massimo Di Pierro
I do not understand On May 31, 6:20 am, Jason (spot) Brower encomp...@gmail.com wrote: I want to change the id of one of my items to the id of one that I have deleted to avoid some URL rot. Basically, I have:http://interestid.com/welcome/default/view_event/12 and I want it to

[web2py] Re: Changing an id... could it be really bad?

2011-05-31 Thread pbreit
You want to avoid changing id's if at all possible because it can easily cause the DB to become inconsistent. I suppose in a worse case scenario you might be able to change it with a database tool (there's an SQLite add-on for Firefox). If you move forward, make sure to consider any other

[web2py] Re: Changing an id... could it be really bad?

2011-05-31 Thread ron_m
If the id in the link the 11 or 12 is then used to reference an id in the database which is an id field in the DAL definition sense then the database engine will usually block you. The id field at the database level is meant to be a non repeating key so reuse of an id numeric value is