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
d...@langille.org
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
