Re: versions table has two rows
Phil Stracchino <[email protected]>
| Newsgroups | gmane.comp.bacula.user |
|---|---|
| Organization | Fenian House Publishing |
| Message-ID | <[email protected]> |
On 9/16/24 15:17, Dan Langille wrote: > > Hello, > > I discovered this situation today when reviewing upgrade instructions for Bacula 9 -> Bacula 15. FYI, Bacula 9 and 13 are both deprecated in FreeBSD and will be removed from the ports tree at the end of the month. > > The problem: duplicate entries: > > bacula=# select * from version ; > versionid > ----------- > 1026 > 1026 > (2 rows) > > bacula=# > > I reckon I can just delete one of them. How to accomplish that is left as an exercise for the reader. delete from version order by version limit 1; -- Phil Stracchino Fenian House Publishing [email protected] [email protected] Landline: +1.603.293.8485 Mobile: +1.603.998.6958