Re: Foreign keys in tables.
Ralf Schlatterbeck <[email protected]>
| Newsgroups | gmane.comp.bug-tracking.roundup.user |
|---|---|
| Message-ID | <[email protected]> |
On Fri, Apr 02, 2021 at 08:01:41PM +0000, Tom Ekberg wrote: > Has anyone given thought to specifying foreign keys? This would have > been very helpful for me today when I deleted a large number of users. > Having foreign keys would have prevented me from doing that. There > were dangling references in issue__journal. Ended up restoring the > _user table from a backup. I think that's the main reason for having 'retire'. This won't create dangling references. I *want* to see what previous users did in the history. So keeping this but retiring the user is the roundup way I think. Ralf -- Dr. Ralf Schlatterbeck Tel: +43/2243/26465-16 Open Source Consulting www: www.runtux.com Reichergasse 131, A-3411 Weidling email: [email protected]