Re: versions table has two rows
"Dan Langille" <[email protected]>
| Newsgroups | gmane.comp.bacula.user |
|---|---|
| Message-ID | <[email protected]> |
On Mon, Sep 16, 2024, at 5:46 PM, Phil Stracchino wrote: > 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; bacula=*# delete from version order by version limit 1; ERROR: syntax error at or near "order" LINE 1: delete from version order by version limit 1; -- Dan Langille [email protected]