Peter,
I don't think any changes to the content repository have occured for OpenACS 5.0. I changed some things on HEAD but I did not change content_folder__new at all.
I do see that 'current_timestamp' is in single quotes. Is that the correct way to pass that in to a timestamp datatype? Normally I see that unquoted.
Which version of Postgresql are you using?