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 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 from version order by version limit 1; Doh, my bad. Forgot you can't use ORDER BY in a DELETE FROM. (Which means you have to use shenanigans when you want to do that.) -- Phil Stracchino Fenian House Publishing [email protected] [email protected] Landline: +1.603.293.8485 Mobile: +1.603.998.6958