julien at trigofacile.com
Thu Dec 24 10:48:21 UTC 2020
>> I see that the removal of a newsgroup is deferred until the next expiration, which is a good thing (preventing an error in a control message or manually with ctlinnd).
> Actually, it's because removing thousands of rows from the article table
> could take some time and shouldn't be allowed to block regular operations.
> Adding a new group does NOT undelete a previous one with the same name.
> I checked carefully what ovdb does in this situation and implemented
> the closest equivalent.
Indeed. I have just tested two successive removals and re-creations:
sqlite> select * from groupinfo where groupid>618;
> Manual undeletion would be a lot easier with ovsqlite than with ovdb,
> since you get a free SQL command line tool with each SQLite installation.
Which is a point to add to the advantages of ovsqlite!
I am really fond of that SQL command line tool to explore the database!
Reinstating a newsgroup removed by error is very simple with that.
We'll now need ovspool for article storage :-)
« Utiliser vi n'est pas un péché, c'est une punition. Car souvenez-vous
que vi-vi-vi est l'éditeur de la Bête. » (Stallman, Church of Emacs)
More information about the inn-workers