PostgreSQL versioncomment update

[Petr Spiller]

Hi,

I'm in desperate need of retaining attachment comment when uploading a new attachment version. I'm brave enough to mess with the database so I went to content table, changed the versioncomment value of the new inserted row and much to my despair the change was not propagated to the client. Moreover, the original attachment comment was back once I uploaded a new attachment version from the client.  Any tips how to change the version commemt outside the client?

Edit: I suppose there is some kind of caching involved. It took about an hour to show the changed comment in client. Is there a way around this?

Edit2: I have found the Content cache needs to be flushed. I have set the cache size to 1 item and now it seems to be working. However, I'm not sure if there are some unforeseen consequences when limiting the content cache in such manner.

Petr

[Nic Brough -Adaptavist-]

Do not alter the database directly.  As you say, there are caching issues, but it's not just the cache you need to worry about, and data may be written back destroying your change.  Your cache change may also cause problems, although it won't corrupt data.

If you insist on doing this with SQL, then you must have Confluence shut down when you do it.

A better option would be to write an add-on that can support your changes.  I would lean towards a Script Runner REST endpoint though.