Re: [Bacula-users] versions table has two rows

2024-09-28 Thread Dan Langille
On Sat, Sep 28, 2024, at 3:37 PM, Phil Stracchino wrote: > On 9/28/24 15:15, Dan Langille wrote: >> >> I found a solution after some searching: use ctid >> >>>From >>>https://www.postgresql.org/docs/current/ddl-system-columns.html#DDL-SYSTEM-COLUMNS-CTID >> >> "The physical location of the row

Re: [Bacula-users] versions table has two rows

2024-09-28 Thread Phil Stracchino
On 9/28/24 15:15, Dan Langille wrote: I found a solution after some searching: use ctid From https://www.postgresql.org/docs/current/ddl-system-columns.html#DDL-SYSTEM-COLUMNS-CTID "The physical location of the row version within its table. Note that although the ctid can be used to locate

Re: [Bacula-users] versions table has two rows

2024-09-28 Thread Dan Langille
On Mon, Sep 16, 2024, at 8:55 PM, Phil Stracchino wrote: > On 9/16/24 20:34, Dan Langille wrote: >> On Mon, Sep 16, 2024, at 5:46 PM, Phil Stracchino wrote: >>> On 9/16/24 15:17, Dan Langille wrote: >>> >>> delete from version order by version limit 1; >> >> bacula=*# delete from version order by

Re: [Bacula-users] versions table has two rows

2024-09-16 Thread Phil Stracchino
On 9/16/24 20:34, Dan Langille wrote: On Mon, Sep 16, 2024, at 5:46 PM, Phil Stracchino wrote: On 9/16/24 15:17, Dan Langille wrote: 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 fro

Re: [Bacula-users] versions table has two rows

2024-09-16 Thread Dan Langille
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 f

Re: [Bacula-users] versions table has two rows

2024-09-16 Thread Phil Stracchino
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-users] versions table has two rows

2024-09-16 Thread Dan Langille
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 ; versi