Hi,

I'm in the process of transitioning from the use of integer ids to guids but I still have a ways to go to finish that plan. After that I plan to examine setting up appropriate constraints. The MS SQL version does currently have more contstraints but it is inconsistent at the moment accross the different data layers. I would welcome your help in defining them for postgresql but I think it will take me a few more releases to get all the guid columns in place and the code changed to use them.

The benefit of switching to guids will be that it will make it easier to implement a feature to import data from one db to another like moving pages and users from one site to another without id conflicts.

Joe

Hi,

If you want to send me script(s) to alter tables and add contstraints as appropriate I will add them in as an upgrade script. Please test after making the changes on your system and let me know if adding these constraints cause any errors like if you try to delete a page and it has child objects like content on it. It should not cause errors but please test some to make sure so that if it does I can fix them.

Over time as a continue making the changes to guids I may have to drop some of these contraints and add different ones.

Thanks,

Joe

joe dot audette at gmail dot com

I think it already deletes child files.

Joe

No I haven't received it, can you send it again?

joe.audette [at] gmail .com

Thanks,

Joe

Hi Vinicius,

Got it this time. I'll review and try to get this into svn in the next few days.

Thanks a lot!

Joe